Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

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.
philmywallet
New Contributor III

Pivot Total Missing ??

I have created a pivot table, but for some reason one of my columns does not show the total.  The script behind this is as follows:

if((PK_Date>=LastRefresh-7) or FiscalWeek='2', sum(FTE))

Any ideas??

Qlik_Pivot.png

1 Solution

Accepted Solutions
MVP
MVP

Re: Pivot Total Missing ??

Try like

Sum( if((PK_Date>=LastRefresh-7) or FiscalWeek='2', FTE))

2 Replies
MVP
MVP

Re: Pivot Total Missing ??

Try like

Sum( if((PK_Date>=LastRefresh-7) or FiscalWeek='2', FTE))

Re: Pivot Total Missing ??

The condition is unfulfilled for the total, the question is:

what are the values for

PK_Date, LastRefresh, FiscalWeek

when you summarize all?

Community Browser