Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
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.