topic Re: Total or calculated dimension in pivot in QlikView

Total or calculated dimension in pivot

Mon, 20 Apr 2015 08:39:59 GMT

Hi, Qlikview profis.

I have a tricky problem here. I have a pivot with the following expression:IF(min(Month_name)>=(vCurMonth),Sum(Sal*Bench_Data*Forecast),Sum({<Y={'2015'}>}Fact_bench)) . I need the total of it, but the problem is that total isnt calculated properly. I try to create a calculated dimension but at the end I get the same problem.

Here is my sample attached. Please help!

Re: Total or calculated dimension in pivot

rubenmarin — Mon, 20 Apr 2015 08:57:33 GMT

Hi Diana, try with this expression:

Sum(Aggr(IF(min(Month(Month_Date))>=($(vCurMonth)),Sum(Sal*Bench_Data*Forecast),Sum({<Y={'2015'}>}Fact_bench)), Month_Date, BG_bench))

And also change vCurMonth to:

=Num(Month(Today()))

Re: Total or calculated dimension in pivot

Mon, 20 Apr 2015 09:09:56 GMT

HI!

Great, thanks!