Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

sofiavaz
Contributor

If statement - ignore filters on a field Qlik sense

Hi all,

Is there any way to ignore the active filters on a sheet, for a table with an if statement?

For example, I have a filters made on my app that mades AllocYear = 2018. But, at one of the app sheet's, there's table that discriminates some orders and I'm using something like this expression:

= If (OrdStat = 'CONFIRM' and Today ()> LateDisp and FinUnits <OrdUnits and InternalServPfeYn = 'N' and InternalServExternalPi = 'N', ItemOrd)

I wanted to add something that would ignore the fact that I have the AllocYear = 2018 made and would make me consider all the orders for AllocYear = 2018 and 2017.

Thank You.

10 Replies
OmarBenSalem
Esteemed Contributor

Re: If statement - ignore filters on a field Qlik sense

alter ur expression as follow:

sum( {<YearField= OrdStat = {'CONFIRM'} , LateDisp={"< $(=Today())"} ,FinUnits ={" FinUnits<OrdUnits"} ,InternalServPfeYn = {'N'} ,InternalServExternalPi ={'N'} >}ItemOrd)


stalwar1‌, do u confirm?

espercially this part : FinUnits ={" FinUnits<OrdUnits"}

sofiavaz
Contributor

Re: If statement - ignore filters on a field Qlik sense

Thanks for your reply, Omar.

This would be a good solution but with the sum function I'll have the amount of orders in that conditions ... I want to insert this expressions into a table in order to see all my orders broken down (order's code)

Re: If statement - ignore filters on a field Qlik sense

Are you using the above as a Measure or dimension?

sofiavaz
Contributor

Re: If statement - ignore filters on a field Qlik sense

As a Dimension

Re: If statement - ignore filters on a field Qlik sense

Any measures in the table or just all dimensions?

sofiavaz
Contributor

Re: If statement - ignore filters on a field Qlik sense

All dimensions!

Re: If statement - ignore filters on a field Qlik sense

I think to make this work... you will need to have at least one expression in your chart...

sofiavaz
Contributor

Re: If statement - ignore filters on a field Qlik sense

What I have is a table ... does that change anything?

Re: If statement - ignore filters on a field Qlik sense

It should not change anything... just add one expression or use one of the dimensions as an expression...

So, for instance....

Dimension

ItemOrd


Measure

=Only({<ItemOrd = {"=OrdStat = 'CONFIRM' and Today() > LateDisp and FinUnits < OrdUnits and InternalServPfeYn = 'N' and InternalServExternalPi = 'N' "}, AllocYear = {'2017', '2018'}>} AnotherField)

Community Browser