topic period wise grouping problem in QlikView

period wise grouping problem

Wed, 25 Nov 2020 16:16:04 GMT

Hi,

i have a small issue with period wise grouping, in my pivot table i have added 'actual' data with 'actual%', if i select period one it displays correctly, but if select Period 1,2,3 the 'actual%' data displays devided/3, i want period wise data. thanks in advance.

Re: period wise grouping problem

Wed, 26 Apr 2017 07:47:19 GMT

Re: period wise grouping problem

vinieme12 — Wed, 26 Apr 2017 07:59:23 GMT

Please provide a more detailed description

https://community.qlik.com/docs/DOC-2380

Re: period wise grouping problem

Wed, 26 Apr 2017 08:09:03 GMT

Hi veneeth i have an issue with selecting period wise . if i select period one the actual% value displays 100% thats right and the same way i was select period 1,2,3 it displays period1 actual% 31%, period2 33% and period3 36% like this, i want if i select Period 1,2,3 that is also display period1 100%, period2 100% and Period3 100% like this.

Plz suggest

Re: period wise grouping problem

Wed, 26 Apr 2017 08:09:16 GMT

i have an issue with selecting period wise . if i select period one the actual% value displays 100% thats right and the same way i was select period 1,2,3 it displays period1 actual% 31%, period2 33% and period3 36% like this, i want if i select Period 1,2,3 that is also display period1 100%, period2 100% and Period3 100% like this.

Re: period wise grouping problem

prachisangewar — Wed, 26 Apr 2017 08:10:22 GMT

Hi,

What formula you use ?

For your requirement you should use AGGR function

e.g.Numerator : AGGR(sum(actual),Period) (and any other dimensions you have)

Similarly for the Denominator for your % should be sum(TOTAL <Period>sum(actual))

If you share your chart logic I can suggest the exact formula to you.

Re: period wise grouping problem

Wed, 26 Apr 2017 08:16:53 GMT

I am using 3 dimensions like Store,Period and one Calculated dim name desc.

Re: period wise grouping problem

Wed, 26 Apr 2017 08:18:42 GMT

and this is my Expression

Re: period wise grouping problem

vinieme12 — Wed, 26 Apr 2017 09:50:42 GMT

Add TOTAL keyword

example

SUM(TOTAL <Periodfield> ...........)

Re: period wise grouping problem

Wed, 26 Apr 2017 11:01:56 GMT

it displays the same data

Re: period wise grouping problem

vinieme12 — Wed, 26 Apr 2017 11:06:36 GMT

Please post a sample app so people here can help you better

Preparing examples for Upload - Reduction and Data Scrambling