Pivot Table Column value differs in Qlik sense

[UserID2626]

Hi,

I have requirement like below image.

For revenue i have FTD,MTD,LMTD and for Profit i don't want to see LMTD. When i give a column name it was assigning for all the measures.

Is it possible to ignore particular column fields for particular measure.

[R_Kaymakchiev]

Hi ,

in the dimention tab, there is a check  'show column if'; 

You can try to write an expression so that if a column value is different then 'LMTD' then show it.

I hope this helps,

Rosen

[jonathandienst · Accepted solution]

You would need to create a dimension with the necessary values, such as this (inline for example):

Dim1:

LOAD Type,
   Dual(Measure, RowNo()) as Measure
 Inline
[
    Type, Measure
   Revenue, FTD
   Revenue, MTD 
   Revenue, LMTD 
   Profit, FTD
   Profit, MTD 
];

Then use these two fields as dimensions as column dimensions and a pick expression of the form:

=Pick(Measure, ... expression for first measure..., ...expression for measure2...,   .... )