2 Replies Latest reply: Apr 12, 2017 11:06 AM by clark meyers RSS

    Case When in UI

    clark meyers

      hello,

       

      i need to implement a custom measure in the UI of qlik sense.

      the main logic is like the following

       

      sum(

        case when type in ('a','b','c') and state in ('0','1') and flag=('yes') then measure1

        case when type in ('a') and state in ('1') and flag=('yes') then measure1

      case when type in ('b') and state in ('0',) and flag=('no') then measure1

      else 0

      end

      )

       

      how can this be handled with set-analysis in the UI ?

       

      can you give me an example for that?

       

      thanks in advance!