Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikView forum consolidation is complete. Labels are now required. LEARN ABOUT LABELS
cancel
Showing results for 
Search instead for 
Did you mean: 
viveksingh
Creator III
Creator III

Update branch based on freez period selection

Hi Experts,

I have Agent details like below

Agent.PNG

Also have Agent branch information where agent may change. as below

Branch.PNG

Expecting results:

lets say Transaction Date , Agent and Freez period are filters.

Selected filters:

Transaction Date= 11/3/2018 , Agent = 222, Freez period= 3/2/2018

Expecting :

Agent 222.PNG

which means based on freez period selection, All sales of the Agent should go to the latest branch on that freez period. 

 

 

 

1 Reply
techvarun
Specialist II
Specialist II

Freez period= 3/2/2018 Looks no data available for the selection.

 

 

Please share sample data in a spreadsheet or in a sample app.