Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
qv_testing
Specialist II
Specialist II

Dashboard

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......

3 Replies
MayilVahanan

Hi

Try like this

=If(GetFieldSelections(Year) = 2005,Sum(Sales),Sum({1}Sales))

Hope it helps

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.
Anonymous
Not applicable

HI Qv_Testing


=sum(load date='2005','2006')

plz try this

pgrenier
Partner - Creator III
Partner - Creator III

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:

CreateState.png

Then, for the graphs you have created, you simply define to which Alternate state they are associated, as such:

DefineStateInChart.png

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