Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.


Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

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