Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld online is next week! REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
nakul1001
Creator II
Creator II

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

nakul1001
Creator II
Creator II
Author

works like a charm! Thank you Anjos.