2 Replies Latest reply: Aug 21, 2015 7:08 AM by Hasvine Dhurmea RSS

    Error in expression

    Hasvine Dhurmea

      Hello All,

       

      I have an issue with a variable which I am trying to create in qlikview.

       

      Here is my expression:

       

      =Count(Distinct{<CampaignId={'1743'}>}{<Jour={'<5'},Time={'>=04:00:00<=15:00:00'}>+<Jour={'sam.'},Time={'>=04:00:00<=08:00:00'}>}{<Date={'>=$(=Date(Max(Date)))<=$(=Date(Max(Date)))'}>}Indice)

       

      I need count of todays 'Indice' on the Campaign Id= 1743

      And the time as mentionned above.

       

      Any idea please.

       

      Many Thanks,

       

      Hasvine

        • Re: Error in expression
          Sasidhar Parupudi

          I would do it in two different counts and add them together.. please try the following expressions seperately in a text object to see if they work?

           

           

          Count(Distinct{<CampaignId={'1743'},Jour={'<5'},Time={'>=04:00:00<=15:00:00'}>}Indice)

          +

          Count(Distinct{<Jour={'sam.'},Time={'>=04:00:00<=08:00:00'},Date={">=$(=Date(Max(Date)))<=$(=Date(Max(Date)))"}>}Indice)

           

           

          also, I have observed  Jour={'<5'} and Jour={'sam.'} which contradict each other.. one is numeric condition the other is a string..may be something missing ??

          hth

          Sasi