Qliksense Pivot Table Issue

[plkinnera]

Hi ,

Based on requirement, I developed a vizlib pivot table. We used 4 dimensions. In those four used one dimension as expression by using only() and another dimension has converted into column as shown below. Here I am missing values in table.

Input data:

Type	Program	Level	status
data	Development	Level 1	Completed
data	Development	Level 2	Queue
data	Development	Level 2	Progress
data	Development	Level 3	Open
data	Development	Level 3	hold

Current Table:

Type	Program	level 1	level 2	level 3
data	Development	Completed	-	-

Expected result:

Type	Program	level 1	level 2	level 3
data	Development	Completed	Queue	Open
data	Development		Progress	hold

Thanks In Advance.

[Gui_Approbato]

Try this:

Instead of using "data" as a measure, use it with an aggr function.

Replace the data field with aggr( Data, status). This might duplicate the rows and fill the fields with the correct values considering the rest of the table.