Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

vanand3535
Contributor

Qlik expression

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

1 Solution

Accepted Solutions
dapostolopoylos
Contributor III

Re: Qlik expression

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

Father/Husband/BI Developer
6 Replies
dapostolopoylos
Contributor III

Re: Qlik expression

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.

Father/Husband/BI Developer
vishalwaghole
Valued Contributor II

Re: Qlik expression

From where you want to delete it.

Can you please explain bit more.

vanand3535
Contributor

Re: Qlik expression

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
Contributor

Re: Qlik expression

I want to use this expression in data load editor,

WHere I'm applying the global filter.

vanand3535
Contributor

Re: Qlik expression

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
Contributor III

Re: Qlik expression

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

Father/Husband/BI Developer
Community Browser