Qliksense Pivot Table Issue

plkinnera — Sat, 16 Nov 2024 18:40:01 GMT

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.

Re: Qliksense Pivot Table Issue

Gui_Approbato — Sat, 16 May 2020 19:05:24 GMT

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.

topic Qliksense Pivot Table Issue in App Development

Qliksense Pivot Table Issue

Re: Qliksense Pivot Table Issue