Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Selection Issue with Date filters

I have 4 pivot tables on a single sheet....

I have 4 date filters on the same sheet....each date filter is associated with each pivot table.......

In qlikview if you select one date filter all 4 pivot tables will change according to selected date....I want only one pivot table to be changed with which it is associated.....and rest of the pivot tables should not change.....

3 Replies
Gysbert_Wassenaar
Partner - Champion III
Partner - Champion III

Create an alternate state and assign that state to the date filter and the pivot table. Selections you make in the date filter should then only apply to the pivot table. Alternatively you could assign the new state to the other three pivot tables so they now ignore all date filters (and other selections).


talk is cheap, supply exceeds demand
Not applicable
Author

Thankyou Gysbert... I am not clear about alternate states....Can you please attach any sample qvw file with 3 objects and 3 filters......Your help would be really appretiable.....

Not applicable
Author

oops...sorry I did not mention I have to do this in QV9.......