0 Replies Latest reply: Feb 18, 2015 4:57 AM by Usman Sikander RSS

    If condition with two columns  joining together

      Good day experts,

       

      I have a very simple question but with Qlikview it seems not that simple. I have two columns the NPS column is aggregated and I have to calculate that on the montly basis. The problem I am facing in joining the data from two different tables. I have to make the line graph to show the development of both the question _name. for example I want to have

       

      " if(question_name='nps' and ROUND(sum(if(NPS='Promotor',1)) / count(TOUCHPOINT)*100

      - (sum(if(NPS='Detractor',1)) / count(TOUCHPOINT)*100))

       

      The statement which starts from round gives me aggregated value which I have to use.

      Similarly I want the same from other question name as well

       

      QUESTION_NAMENPS
      NPSPromotor
      NPSdetractor
      TNPSpromotor
      TNPSdetractor