10 Replies Latest reply: Jan 10, 2018 7:58 AM by Sofia Vaz RSS

    If statement - ignore filters on a field Qlik sense

    Sofia Vaz

      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.