4 Replies Latest reply: Feb 8, 2016 3:15 AM by Roland Loykens RSS

    QlikView set analysis filter on all fields from one table

    Roland Loykens

      Hi all,

       

      Does anyone know if it's possible to have set analysis react only on filters that are set on the fields of one table and disregard the filters on fields of all other tables?

       

      I want to sum the field Quantity only if a filter is set on any field from the Calendar table.

       

      I've found an example that does the opposite, it disregards the filters on all fields of the Calender table, but I can't find a way to turn it around.....

       

      =sum({$<[$(=Concat({1<$Table={'Calendar'}>}distinct $Field,']=,[')&']=')>} Quantity)

       

      Does anyone have a fix for this?

      Thanx in advance!!