Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

New Contributor III

'Group by' Issue


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 

3 Replies
Honored Contributor II

Re: 'Group by' Issue

what's your current script ?
New Contributor III

Re: 'Group by' Issue

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.
New Contributor III

Re: 'Group by' Issue

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.


Kundan S