topic Re: total issue in pivot !!! in QlikView

total issue in pivot !!!

qliklearnervir — Mon, 19 Mar 2018 06:33:33 GMT

Hi,

I am working on one expression where i am not able to find out right solution.

i wan to show the table with :

Segment	Mix	Mix %
A	10	0.333333
B	10	0.333333
C	10	0.333333
Total	30

this is easily achievable by Mix% = SUM(TOTAL {<Segment>} Mix).

But the problem here is if we need to change the dimension from segment to Market or so on as per conditional dimension selection . this static formula will not work.

i want the dynamic formula where if i change the dimension tan total should change as per dimension subtotal.

Like Mix%=SUM(TOTAL {<Dynamic Dimension>} Mix )...

Please suggest.

Thanks.

Virendra

Re: total issue in pivot !!!

PrashantSangle — Mon, 19 Mar 2018 06:42:33 GMT

create variable to store your dynamic dimension

and use that variable in your

Mix%=SUM(TOTAL {<$(variableName)>} Mix )

Regards,

Re: total issue in pivot !!!

qliklearnervir — Mon, 19 Mar 2018 08:12:05 GMT

It is not working ...

still showing total values for entire year

Re: total issue in pivot !!!

sasiparupudi1 — Mon, 19 Mar 2018 08:30:58 GMT

Aggr(sum(TOTAL<$(=vDynamicDims)> Mix),Dim1)

Re: total issue in pivot !!!

qliklearnervir — Mon, 19 Mar 2018 08:35:26 GMT

I have to add the current year and previous year selection also.

for 2 columns ..

for current year its working file Sum ( Actual) / Sum (Total < $(Dim1)> Actual) ....

but for previous year ...its not working....