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

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
MK_8
Contributor II
Contributor II

How to filter Dimension

Hi All, 

I was working on a Chart with Dates columns on Dimension and I want to filter out the years with no data and less data, in the given case I want the chart to show data from 2015.

MK_8_0-1666008629861.png

Thanks in advance. 

Labels (4)
1 Reply
BrunPierre
Partner - Master II
Partner - Master II

As a calculated dimension as below thus suppressing null values.

IF(Year >= 2015, Year)

Alternatively, you can include this modifier in your expression.

({<Year = {">=2015"}>}