Pivot Table

[Satish251]

Hello All,

with below attached data i am trying to create pivot table as 

dim - Dim1 -> dim2 -> dim3 

measure - measure 1  -> measure 2

and in appearance only intended rows is selected  and give me resulat as follows.

if i expand 1 dim then it shows only dim2 value and dim1 value blank and if i expand till dim3 then measure value for dim1 & 2 shows blank , only shows dim3 value.

Default as Measure value for Dim1,

on 1st expand measure shows value for dim2 of respective dim1

and 2nd expension measure shows values of dim3 of respective dim1 and dim 2

as below images 

dim1

dim2 : 

dim 3 :

[Lisa_P]

You can use the dimensionality function to decide what to show based on how deep you have expanded into the dimensionality of the chart.

eg if(dimensionality()=1, ...,

)

[PrashantSangle]

try with dimensionality() and secondarydimensionality()

https://help.qlik.com/en-US/qlikview/May2023/Subsystems/Client/Content/QV_QlikView/ChartFunctions/In...

SecondaryDimensionality()

https://help.qlik.com/en-US/qlikview/May2023/Subsystems/Client/Content/QV_QlikView/ChartFunctions/In...

Regards,

Prashant Sangle

[Satish251]

Can someone help me with expression

[Lisa_P]

[Satish251]

I have to use Both measure together , check attached images if dimension is expanded then inner dimension value is available and above value should show blank 

[Lisa_P]

If you turn off Indent Rows in Presentation section of properties, it will look like this:

[Satish251]

hello lisa,

thanks for your solution,

please find below referance image , i am treying to achive this 

in above image dim1 and dim2 dim3 is expanded and its respective measure value m1 m2 for dim1 and dim2 is blank