Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

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".

Tags (4)
1 Reply
Not applicable

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?

Community Browser