Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
andyscslots
New Contributor III

using the if statement while ignoring filters

I'm using the expression below on a line chart that includes a month filter as the chart shows data on a monthly basis

Avg(if(Year>=2016,value))

Using the same expression I want to be able to ignore the month filter.

I have previously used set analysis Avg({$<Month=>},value) to ignore the month filter but I'm not sure how to add the if statement

Thanks for your assistance

Regards,

Andy

1 Solution

Accepted Solutions
andyscslots
New Contributor III

Re: using the if statement while ignoring filters

Hi Youssef,

I used your expression  as follows and it worked, thanks

Avg({$<Month=>}if(Year>=2016,value ))

4 Replies
YoussefBelloum
Esteemed Contributor

Re: using the if statement while ignoring filters

Hi,

try this:

Avg({<Year=>}if(Year>=2016,value))

andyscslots
New Contributor III

Re: using the if statement while ignoring filters

Hi Youssef,

I used your expression  as follows and it worked, thanks

Avg({$<Month=>}if(Year>=2016,value ))

thiago_justen
Valued Contributor III

Re: using the if statement while ignoring filters

I guess this will solve it:

Avg ({<Month=>}If (Year>=2016,value))

Cheers

Thiago Justen Teixeira Gonçalves
WhatsApp: 24 98152-1675
Skype: justen.thiago
thiago_justen
Valued Contributor III

Re: using the if statement while ignoring filters

Too late...

Sorry!

Thiago Justen Teixeira Gonçalves
WhatsApp: 24 98152-1675
Skype: justen.thiago