2 Replies Latest reply: Sep 19, 2018 3:17 PM by Jerry Jackson RSS

    If Then Else with SimpleFieldSelect

    Cheryl Richter

      Qlik Sense only please.

       

      I'm using a formula in the Qlik Sense Extension Simple Field Select:

       

      =IF (TYPE = 'A', 'TYPE A',

      IF (TYPE = 'B', 'TYPE B',

      IF (TYPE = 'C', 'TYPE C')))


      Which is great, I get a checklist box with Type A, Type B and Type C.  Now the users would like an ALL TYPES selection that when the click on it they get TYPE A, TYPE B and TYPE C.  I know that the default when they make no selection is all types, but we're all about the customer service. 

      Note there is no data in the TYPE field called "ALL TYPES". 


      =IF (TYPE = 'A', 'TYPE A',

      IF (TYPE = 'B', 'TYPE B',

      IF (TYPE = 'C', 'TYPE C',

      TYPE)))

       

      Trying this code doesn't produce a selection for "ALL TYPES" in the extension.  Is there a way to amend this syntax to do this?

       

      Cheryl

       

      Thank you again so much for your help.