Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Announcements

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.

Highlighted
kundan_sharma1
New Contributor III

'Group by' Issue

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 

3 Replies
agigliotti
Honored Contributor II

Re: 'Group by' Issue

what's your current script ?
bhavikumehta
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.
kundan_sharma1
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.

Regards,

Kundan S