Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Nov. 20th, Qlik Insider - Lakehouses: Driving the Future of Data & AI - PICK A SESSION
cancel
Showing results for 
Search instead for 
Did you mean: 
venkat1
Creator II
Creator II

showing max (date) sales in pivot table by default and sales by selecting the year and month objects

Hi 

i need a help from you regarding a scenario.

i am having year and month list boxes and pivot table with sales of gold and diamond by branch wises,

my requirement is to show by default max(date) sales ,where date fields are different for the gold and diamond,eg. g.vou_date,d.vou_date, now if i select the year and month list box then sales should come accordingly.

 

i tried with open sheet triggers of two field events with d.vou_date and g.vou_date but it was not working. 

1 Reply
sunny_talwar

Would you be able to share a sample where you have tried out and it wasn't working? Also, please specify what didn't work and what were you hoping it would do?