topic Re: total in pivot table in QlikView

total in pivot table

Tue, 07 Apr 2015 13:47:56 GMT

Hi!

I have a pivot with an expression:IF(min(Month_name)>=(vCurMonth),Sum(Sal*Bench_Data),Sum({<Y={'2015'}>}Fact_bench))

	Q1	Q2	Q3	Q4
BG_bench	Bench 2015, USD	Bench 2015, USD	Bench 2015, USD	Bench 2015, USD
BG1	77,360	70,660	122,394	176,394
BG2	0	0	0	0
BG3	0	0	0	0
BG4	0	0	0	0
BG5	0	0	0	0
BG6	0	0	0	0
BG7	0	0	0	0
BG8	0	0	0	0
Total	77,360	70,660	122,394	176,394

It works perfectly with quarters, but it doesnt work in 'Total'. The 'Total' shows me only the result of the 1st quarter.

Any ideas how to fix this prob?

Re: total in pivot table

Anonymous — Tue, 07 Apr 2015 13:51:55 GMT

It would be great if you can share sample application

Re: total in pivot table

buzzy996 — Tue, 07 Apr 2015 13:55:37 GMT

try this

IF(min(Month_name)>=Sum(Sal*Bench_Data),Sum({<Y={'2015'}>}Fact_bench))

IF(min(Month_name)>=(here create/put ur variable for year),Sum(Sal*Bench_Data),Sum({<Y={'2015'}>}Fact_bench))

Re: total in pivot table

Tue, 07 Apr 2015 13:59:37 GMT

Nope, this doesnt give me any result

Re: total in pivot table

Anonymous — Tue, 07 Apr 2015 14:10:30 GMT

or reset Month_name

Sum({<Y={'2015'},Month_name=>}Fact_bench)

try to use total where datedimension should

Sum(total <yourdatedimension>{<Y={'2015'}>}Fact_bench)

Re: total in pivot table

Thu, 09 Apr 2015 13:40:00 GMT

Here is my sample data. As u can see total isnt calculated corrreclty because of the IF statement, and the calculated dimension isnt working also

Re: total in pivot table

ramoncova06 — Thu, 09 Apr 2015 14:31:34 GMT

change your variable to date((today()),'MMM'), if you use the monthname function QV will consider it a string, but in your script you are actually setting it as a date

Re: total in pivot table

Thu, 09 Apr 2015 15:30:05 GMT

When I change the variable to date((today()),'MMM') the expression isnt working