Discussion board where members can get started with Qlik Sense.
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.
Go to Solution.
You would need to create a dimension with the necessary values, such as this (inline for example):
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..., .... )
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,