Group table data by a column values

srinivas17 — Mon, 12 Jul 2021 11:07:02 GMT

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

Id	date	incidence	material	thickness
1	12/7/2021	A	material1	17
1	12/7/2021	C	material2	26
1	12/7/2021	D	material3	35
1	12/7/2021	B	material4	44
1	12/7/2021	C	material5	8

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 :

Id	date	incidence	material	thickness
1	12/7/2021	A	material1	17
		B	material4	44
		C	material2	26
		D	material3	35
		A
		B
		C	material5	8
		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

topic Group table data by a column values in App Development

Group table data by a column values