topic Re: Pivot table Dimensions based on sub fields and expressions in Visualization and Usability

Pivot table Dimensions based on sub fields and expressions

Re: Pivot table Dimensions based on sub fields and expressions

Re: Pivot table Dimensions based on sub fields and expressions

Re: Pivot table Dimensions based on sub fields and expressions

Re: Pivot table Dimensions based on sub fields and expressions

shanu_s9 — Mon, 17 Apr 2023 11:44:37 GMT

Hello Experts,

I want to display my data in the below format, but i count not able to see any such object.
here AD has direct values and TOP VIEWER & BOTTOM VIEWER have different areas data need to display like this. I have around 6 or 7 dimension info need to show same way based on areas.

Any extension/ method can display in qlik sense please suggest and help me.

Thanks in advance.

Or — Mon, 17 Apr 2023 12:30:55 GMT

This looks like a standard pivot table. What exactly is the problem you are facing?

Kushal_Chawda — Mon, 17 Apr 2023 14:15:24 GMT

are top viewer and bottom viewer present in data? Probably sample data would help

shanu_s9 — Mon, 17 Apr 2023 15:17:03 GMT

Thank you for your support,

If I add one dimension it is coming as expected, but when i add 2nd dimension then it is going under 1st dimension and values

Example: expecting

Alpha | Beta

A | B| C| E| F| G

But coming as

Alpha

Beta

A| B|C|D|E|F

TOP VIEWER

BOTTOM VIEWER

Or — Tue, 18 Apr 2023 10:00:49 GMT

Drag it to the left of "Values" (or vice versa).