Regarding pivot table

Wed, 27 Jul 2011 20:17:36 GMT

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

Wed, 27 Jul 2011 20:47:22 GMT

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?

topic Regarding pivot table in QlikView

Regarding pivot table

Regarding pivot table