1 Reply Latest reply: Jul 27, 2011 4:47 PM by jukes231 RSS

    Regarding pivot table

      Hi Everyone,

      Lately I am working on a pivot table issue. I posted this question but I guess I wasn't clear enough.

      Here, I am trying again.

       

      I have attached a print screen of the pivot table I am working on.

       

      The formula that I used to calculate the "Test" is this:

       

      sum({$<

      FACT_TYPE={'Current'},

      FLAG_HEALTH_REPORT={'1'},

      REVENUE_RECOGNITION_FLAG =REVENUE_RECOGNITION_FLAG-{'No'},

      IS_PART_ACTIVE={'1'},

      MODIFIED_DATE={"<=$(vMaxDate)"}>}

      total <Bucket_Test,STAGE> total [TOTAL_VALUE])

       

      and the Cyclic Group is named as "Group 1".

        • Regarding pivot table

          are you trying to sum the literals defined (Fact_type='Current', Flag_Health_Report='1', etc) or do you want that to be dynamic?    Have you tried to add Tier Geo to your total <Bucket_Test,STAGE> ?

           

           

          some of the calc concepts in Qlikview are new to me.  Have you tried using an aggr function?