Pivot Table Help (somewhat complex)

Anonymous — Sat, 04 Nov 2017 11:20:00 GMT

Thank you in advance for your help.

I have a pivot table below that calculates the "Actual", "Scheduled", "Budget" for the week.

I want to add a measure that has "Weekly Average" using the past 6 months. This measure excludes any "time series dimensions" as users will be changing the weeks they will be evaluating.

I created the set analysis below but it doesn't work in the pivot table (Note - I tried ignore the timing dimension [Period NameN]=)

If I take the same set analysis below and put it into a KPI.. it calculates fine.

I have a feeling the dimension column (Weekly intervals) is screwing with the set analysis for that measure.

As mentioned before, I tried to ignore that dimension [Period NameN]= but I don't think that worked.

(Count({<WeekDay={'Mon'},

[Period Name]={'6 Month Rolling'}

,[Period NameN]=>}

AccountCount)

Count({<WeekDay={'Mon'},

[Period Name]={'6 Month Rolling'}

,[Period NameN]=>}WeekDay))

Re: Pivot Table Help (somewhat complex)

Anonymous — Mon, 06 Nov 2017 13:14:02 GMT

Bump

topic Pivot Table Help (somewhat complex) in QlikView

Pivot Table Help (somewhat complex)

Re: Pivot Table Help (somewhat complex)