Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Populating dimension values based on the selection

Hello QV Experts,

I have a line chart that shows count of Assets (Y axis) per Calendar Year (X axis). In the dashboard there is a list box for field Calendar Year.

When I select a value in Calendar Year list box (eg: 2013) the line chart gets updated such that it only shows 2013 in x axis. I know this is expected however a line chart with just one dimension value in X axis is not quite meaningful.

What I am trying to achieve is this:-

When a user selects a year in Calendar Year list box (eg: 2010) then I want the line chart to show 3 values in X axis: selectedyear-1 , selectedyear and selectedyear +1 (eg: when 2010 is selected in Calendar Year list box, the x axis of line chart should plot for: 2009, 2010 and 2011)

I am trying to get this done using calculated dimension with IF statements but no luck so far.

Ideas?

Thanks

Nakul

1 Solution

Accepted Solutions
Clever_Anjos
Employee
Employee

Please check if fits your needs

View solution in original post

2 Replies
Clever_Anjos
Employee
Employee

Please check if fits your needs

Anonymous
Not applicable
Author

works like a charm! Thank you Anjos.