Hide Measure based on Dimension Values in Pivot table in Qlik sense

KishorePandurangan — Sat, 16 Nov 2024 02:17:37 GMT

Hi,

I have fields called Product and its measures related to the product.

In below table, Product and Country (Country A and Country B) are dimensions. Country dimension is being dragged top next to measure.

And Measure is a expression, which is pulled as a column next to product.

1. sum(value) as SUM

2. AVG(value) as AVG

Product A only has measure SUM not AVG, similarly Product B only has AVG not SUM.

I want Measure AVG to be hidden for Product A, and Measure SUM to be hidden for Product B.

Output:

Thanks.

topic Hide Measure based on Dimension Values in Pivot table in Qlik sense in App Development