Dynamic Loading of Tables in Qlikview/Qliksense

Capture.PNG

 

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 & ‘-‘ & index;
tableNumber = TableNumber(currentName)
matches = Match(‘$(currentName)’, $(dataManagerTables));
Loop
If index > 0 then
Rename Table ‘$(name)’ to ‘$(currentName)’;
EndIf;
Next;
Set dataManagerTables = ;

Advertisements

100 Ways

100-Ways-to-Motivate-Others

andu korralu – Foxtail Millets
korralu – Foxtail Millets
arikelu – Kodo Millets
samalu – Little Millets
varigalu – Proso Millets

https://drive.google.com/file/d/1sLG2juCAuamrlVT9fjuw4j_P8G2dLP0D/view https://drive.google.com/file/d/1ioXu5n2OIyH-XC03lgMzU9YuwPoYQbAs/view

__https://www.youtube.com/watch?v=owuMdgHXgzI

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

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 Raju,31/08/2018 12:00:00 AM,2
John Saida,30/09/2018 12:00:00 AM,3
Ramesh,21/08/2018 12:00:00 AM,2
Name1,20/09/2018 12:00:00 AM,0
Name2,21/08/2018 12:00:00 AM,0
Name3,20/07/2018 12:00:00 AM,5
Babu,11/09/2018 12:00:00 AM,3
Modi,07/10/2018 12:00:00 AM,9
];

Capture.JPG