Qlik expression

[vanand3535]

Hi all,

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

MATCH(SEASON,'9999','2018')=0

[dapostolopoylos]

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.

[VishalWaghole]

From where you want to delete it.

Can you please explain bit more.

[vanand3535]

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).

[vanand3535]

I want to use this expression in data load editor,

WHere I'm applying the global filter.

[vanand3535]

example :-

season: 2010,2011,2012,2013,2014

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.

[dapostolopoylos · Accepted 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

     Match(Season,'2014','2015','2016','2017')

or

WHERE

     Season>2013

AND

     Season<2018