topic 'Group by' Issue in QlikView

'Group by' Issue

kundan_sharma1 — Sat, 16 Nov 2024 21:36:59 GMT

Hi,

I have one measure calculated on the basis of 14 dimension.

I want that my output looks like the same as shown in output sheet on the basis of grouping, but when I try to group the them I get the output like the third sheet.

Input sheet is the data extracted from the chart.

Attached file has input as well as output

Re: 'Group by' Issue

agigliotti — Fri, 11 Jan 2019 10:21:36 GMT

what's your current script ?

Re: 'Group by' Issue

bhavikumehta — Fri, 11 Jan 2019 10:49:22 GMT

If you want a Straight table to look same as 'Output' sheet, then no need to use 'Group by'.
Create a Straight table with Field6 as Dimension and sum(Total) under Expression.
Please let me know if it works.

Re: 'Group by' Issue

kundan_sharma1 — Fri, 11 Jan 2019 11:10:17 GMT

Hi Bhavik,

When i take only field6 as dimension then all the values are being considered for sum and the output is shown as on the 3 rd sheet.

Regards,

Kundan S