Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Limit Date Dimension on Graph

Hi All,

I have monthly data, but on the line chart I only want to display December 2014, December 2015 and the current selected period.

I created a calculated dimension and hard coded the dates.  How do I make the third data point dynamic to use the selected period.

=if(MonthName & ' ' & Year  = 'December 2014' or MonthName & ' ' & Year  = 'December 2015' or

MonthName & ' ' & Year  = 'May 2016',Month & ' ' & Year,Null)

1 Reply
Gysbert_Wassenaar

Can you post a small qlikview document that demonstrates the problem?


talk is cheap, supply exceeds demand