5 Replies Latest reply: May 23, 2018 4:46 AM by Sunny Talwar RSS

    Qliksense - Ignore only one selection

    Arwin Pablo

      Is there any other form of set analysis that would ignore only one selection in Qliksense aside the code below?

      Both codes are not ignoring the month selection. I'm pretty sure that I'm suing the correct field, Month.

       

      If(vCurrency_1 = 'CND',

      Sum({$<Currency = {'CND'},Month>}Budget),

          Sum({$<Currency = {'USD'},Month>}Budget)

         )

       

      or

       

      If(vCurrency_1 = 'CND',

      Sum({$<Currency = {'CND'},Month = >}Budget),

          Sum({$<Currency = {'USD'},Month = >}Budget)

         )