topic Re: Totals on percentage keep on chaging in QlikView

Totals on percentage keep on chaging

Shiva123 — Fri, 02 Mar 2018 18:58:12 GMT

Hello,

all i am having trouble to display the same totals, while selecting the dimensions . my calculation is a combination of

gross amount - if flag = yes qty * asp , gross amount / gross amount and i have tried sum(aggr(.... dim1) dim1 meaning the calculation

which should not change, i have tried total function total<dimesion1 > . even i tried in the set analysis sum( dimension1 =, amt) nothing

worked . is there any solution for this . attached is the copy , the dimension is quarter which is the selector , the column to see is Rate

that is the one keeps on changing while selecting the SELECTOR quarter ,

Thanks in advance . !

Re: Totals on percentage keep on chaging

sunny_talwar — Fri, 02 Mar 2018 23:06:31 GMT

So, no matter which quarter you select, you want to see 52% on all rows of the chart?

Re: Totals on percentage keep on chaging

Shiva123 — Fri, 02 Mar 2018 23:10:56 GMT

nope only the totals , if u change the cyclic group to period , you can see the exact problem . meaning when you the select the quarter from selector the rate value calculates automatically which it should not

Re: Totals on percentage keep on chaging

Shiva123 — Fri, 02 Mar 2018 23:16:15 GMT

sorry even the row value only for period dimension ..

thanks

Re: Totals on percentage keep on chaging

Shiva123 — Mon, 05 Mar 2018 17:22:07 GMT

did u get any chance to look at this stalwar1‌

thanks

Re: Totals on percentage keep on chaging

sunny_talwar — Mon, 05 Mar 2018 17:23:16 GMT

I think I am having a little hard time understanding what is not working. Can you share using images what is the issue?

Re: Totals on percentage keep on chaging

Shiva123 — Mon, 05 Mar 2018 18:36:41 GMT

stalwar1‌ see when selecting the selector quarter the rate changes which it should not. on the other hand it should also perform its(rate) calculations when selecting other dimensions in the cyclic group, but for period the total and individual row values should be same . because that rate is driving other calculations .

please let me know if you need information . thanks for help ..

Re: Totals on percentage keep on chaging

sunny_talwar — Fri, 09 Mar 2018 20:36:46 GMT

Check attached

Re: Totals on percentage keep on chaging

Shiva123 — Fri, 09 Mar 2018 21:02:16 GMT

it works exactly what i wanted, but the thing is that i have just scrambled data here in the attachment , when i take the exact formula and replace in my original qvw it doesn't work ..

Re: Totals on percentage keep on chaging

Shiva123 — Fri, 09 Mar 2018 21:08:48 GMT

sorry my bad it . works .. perfectly... stalwar1 you are amazing... .. i have no words for you .. simply superb ...

awesome ..sunny