# New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

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

## Re: Qlik expression

If i get it straigth you want to include season over 2013 until 2018 and not equal to 9999.

WHERE

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

or

WHERE

Season>2013

AND

Season<2018

Father/Husband/BI Developer
6 Replies
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?

Father/Husband/BI Developer
Valued Contributor II

## Re: Qlik expression

From where you want to delete it.

Can you please explain bit more.

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

Contributor

## Re: Qlik expression

I want to use this expression in data load editor,

WHere I'm applying the global filter.

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.

Contributor III

## Re: Qlik expression

If i get it straigth you want to include season over 2013 until 2018 and not equal to 9999.

WHERE

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

or

WHERE

Season>2013

AND

Season<2018

Father/Husband/BI Developer