Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Save $650 on Qlik Connect, Dec 1 - 7, our lowest price of the year. Register with code CYBERWEEK: Register
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
Partner - Champion III
Partner - Champion III

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


talk is cheap, supply exceeds demand