Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
kundan_sharma1
Contributor III
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 

Labels (3)
3 Replies
agigliotti
Partner - Champion
Partner - Champion

what's your current script ?
bhavikumehta
Contributor III
Contributor III

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
Contributor III
Contributor III
Author

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