3 Replies Latest reply: May 3, 2016 5:27 AM by Subba Reddy RSS

    How to write Nested If in Set Analysis?

    Subba Reddy

      Hi,

       

      I have a query like

       

      =IF(MajorSiteRegion in ('3.P.L','Corus','Fremont','India','Livermore','Metryx','San Jose','Silfex','Tualatin','Villach'),MajorSiteRegion)

       

      In Qlikview it wont allow IN function. How to write the same in Set Analysis or any other alternate way..

       

      Sub2u444