Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
year 2005,2006,2007
I have dashboard in that i have 10 charts if i am click the year 2005
i want to reflect only 3 chart, click 2006 i want reflect other 3 charts.
Thanks in Advance......
Hi
Try like this
=If(GetFieldSelections(Year) = 2005,Sum(Sales),Sum({1}Sales))
Hope it helps
Good day Raju,
You may achieve this by enabling the Alternate States in your QlikView document, and creating three different states for each analysis axis, as such:
Then, for the graphs you have created, you simply define to which Alternate state they are associated, as such:
This chart will only interact with other elements or objects that are related to it, meaning that only listboxes and charts having been associated to the same analysis axis shall have its contents refreshed.
Regards,
Philippe