Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a dimension YEAR which shows values from 2008 to 2015. However the data is available only from 2011-2015. How do I not display those extra values.?
Qlik can only show data that is actually in the application, so apparently you DO have data for 2008, 2009 and 2010.
If this is the result of a Master Calendar being created from a too early date, adjust that in your script.
From 2008 to 2010 it is greyed out. I want to remove the grey values. How should I proceed?
I think your link the date fields from two table that's why you getting additional dates.
You can add a expression in the list box like if(YEAR>='2011',YEAR)
or you can reduce the data in the script level by applying the where conditions
or
create a extra field in the table where you need to refer the YEAR
go to>list box>in the dimension list > at last you have option called expression>add this
if(YEAR>='2011',YEAR)
Try Hide excluded option
Doesn't work Avinash! It creates an extra column in listbox!
With hide excluded it just hides the values....I mean the grey area still stays!
try like this :
if(YEAR>='2011',YEAR,null())