Qlik Community

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
Read about the latest Qlik Community enhancements on the Community News blog!
cancel
Showing results for 
Search instead for 
Did you mean: 
srinivas17
Contributor
Contributor

Group table data by a column values

Hi, 

I have requirement in qlik sense to group the table data by a column values (A, B, C, D) and add new rows for missing values in the group.

Ex:  My table data is in below format 

 

Iddateincidencematerialthickness
112/7/2021Amaterial117
112/7/2021Cmaterial226
112/7/2021Dmaterial335
112/7/2021Bmaterial444
112/7/2021Cmaterial58

 

In the above table , for the Column Id 1 , after grouping the incidence column by A,B,C, D ; one more C is left for which new group has to be created with A, B, D and other field values for these new rows A, B, D should be empty

Expected output table :

Iddateincidencematerialthickness
112/7/2021Amaterial117
  Bmaterial444
  Cmaterial226
  Dmaterial335
  A  
  B  
  Cmaterial58
  D  

 

I tried by creating an inline table for Incidence column 

IncidenceTable:
Load * Inline [
Incidence
A
B
C
D];

 

and right join this IncidenceTable with my actual table to group the table data by Incidence column values A,B,C,D. But this is creating 4 new rows for each row in actual table. but requirement is to add new rows for only missing values in the Group (A, B, C , D).

 

Any help is appreciated or please let me know if any extension is present to show the table data in this format

0 Replies