Skip to main content
Announcements
Qlik Connect 2025: 3 days of full immersion in data, analytics, and AI. May 13-15 | Orlando, FL: Learn More
cancel
Showing results for 
Search instead for 
Did you mean: 
abc_18
Creator II
Creator II

How to aggregate multiple rows in a single rows in a straight table

Hello everyone,

How can I aggregate the values where I can see "- Other" in a single row and this needs to be handled at chart level only because have multiple measure against those values being calculated using chart expression. 

X-Y a x y z q w e r t y
 -    126 0 41 75 8 .41% 0.03% 0 8
Data related to order - X,Y,Z a-2 45 0 0 15 1 .05% 0.00% 0 1
Order placed - A,B,C N/A 33 0 20 90 8 .39% 0.03% 0 8
22.2.2 - Other   24 0 0 2 0 .01% 0.00% 0 0
22.2.3 - Other   7 0 5 0 0 .02% 0.00% 0 0
22.3.1 - Other   8 0 0 3 1 .01% 0.00% 0 1
22.4.0 - Other   9 0 8 3 0 .04% 0.00% 0 0
22.5.1 - Other   7 0 0 2 0 .01% 0.00% 0 0
22.5.2 - Other   6 0 2 3 0 .02% 0.00% 0 0
22.6.5 - Big order a-3 4 0 0 1 0 .% 0.00% 0 0
22.6.7 - 450GH a-5 4 0 0 0 1 .% 0.00% 0 1
Labels (1)
3 Replies
mdmukramali
Specialist III
Specialist III

Hi,

can you try to add a calculated dimension in the straight table something like below.

=IF(WildMatch([X-Y],'*Other'),'OTHERS',[X-Y])

it will group all the values which contain Other.

 

mdmukramali_0-1669701896335.png

 

West69
Contributor II
Contributor II

You can concatenate rows into single string using COALESCE method. This COALESCE method can be used in SQL Server version 2008 and higher. All you have to do is, declare a varchar variable and inside the coalesce, concat the variable with comma and the column, then assign the COALESCE to the variable.
AvalonAccess

abc_18
Creator II
Creator II
Author

Hi, Expectation is as below:

We need to show these Other values as comma separated not like it will go to one column as "Other".

Before'-' numbers are different so we need to combine all those value in one row and expressions also need to be aggregate. For ex have done for column x (24+7+8).

X-Y a x y z q w e r t y
 -    126 0 41 75 8 .41% 0.03% 0 8
Data related to order - X,Y,Z a-2 45 0 0 15 1 .05% 0.00% 0 1
Order placed - A,B,C N/A 33 0 20 90 8 .39% 0.03% 0 8
22.2.2 - Other, 22.2.3 - Other, 22.3.1 - Other   39 0 0 2 0 .01% 0.00% 0 0