Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
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.