Dynamic Loading of Tables in Qlikview/Qliksense

  Set dataManagerTables = ”,’FinalItemMaster’,’AggSales’,’CustomerAddress’,’Customers’,’FinalItemBranch’,’FinalSalesHeader’,’FinalYTDBudget’,’Province’,’Sales’,’US STATES’,’SalesDetails2′,’Dates3′; //This block renames script tables from non generated section which conflict with the names of managed tables For each name in $(dataManagerTables) Let index = 0; Let currentName = name; Let tableNumber = TableNumber(name); Let matches = 0; Do while not IsNull(tableNumber) or (index > 0 and matches > 0) index = index + 1; currentName = name & … Continue reading Dynamic Loading of Tables in Qlikview/Qliksense

Taks 10 Oct 2018

https://community.qlik.com/thread/131018 https://community.qlik.com/thread/316845 https://community.qlik.com/message/1555453 https://community.qlik.com/message/1555623   Permanent Address Sravanthi Apartments,Prakasam Nagar,Rajahmundry – 533 103,Andhra Pradesh Delhi Address 187, South Avenue,New Delhi – 110 011 Mobile 9868180171,9868180171 Phone 011-23795075,0883-2460002, 0883-2460003 Fax 0883-2425242 Email address Continue reading Taks 10 Oct 2018

How to show max date and its Sales?

https://community.qlik.com/thread/316205 Use DATE#,Left functions. Search in Qlikview Help Data: Name Date Sales Modi 07/10/2018 12:00:00 AM 9 Babu 11/09/2018 12:00:00 AM 3 Name3 20/07/2018 12:00:00 AM 5 Name1 20/09/2018 12:00:00 AM 0 Name2 21/08/2018 12:00:00 AM 0 Ramesh 21/08/2018 12:00:00 AM 2 John Saida 30/09/2018 12:00:00 AM 3 Gopi Raju 31/08/2018 12:00:00 AM 2 Check this thread: https://community.qlik.com/thread/315995 Data: LOAD * INLINE [ Name,Date,Sales Gopi … Continue reading How to show max date and its Sales?