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