Discussion board where members can get started with Qlik Sense.
I need expression for the following:-
1. if(season<2013) then delete all the season
2. if(season are in(9999 , 2018)) then delete
I normally use :-
Go to Solution.
If i get it straigth you want to include season over 2013 until 2018 and not equal to 9999.
If this is your case then you could add a WHERE statement in your LOAD script:
Where do you want to use this expression, in a chart or script?
You want to actually delete data or hide them?
Be a little more descriptive about your problem so we can help you.
From where you want to delete it.
Can you please explain bit more.
yes, delete means I don't want to use in my calculation and if there will be some value for it then it will make it as 0.
so that it won't affect that calculation
I normally use it as 0(zero).
I want to use this expression in data load editor,
WHere I'm applying the global filter.
I have bar chart where dimension is "SEASON",
If i will create measure for calculating sum then it will be:
sum(Sales) which include the season from 2010 to 2014
But I want to display sales >2013.
I have a huge number of graph and tables where I'm using SEASON Value >2013 so ,everytime it's tough to apply the same filter that's why I'm applying the global filter in data load editor.