Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Highlighted
UserID2687
New Contributor III

Pivot Table Column value differs in Qlik sense

Hi,

I have requirement like below image.

Capture.JPG

 

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.

1 Solution

Accepted Solutions
MVP
MVP

Re: Pivot Table Column value differs in Qlik sense

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...,   .... )

 

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
2 Replies
R_Kaymakchiev
New Contributor III

Re: Pivot Table Column value differs in Qlik sense

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

MVP
MVP

Re: Pivot Table Column value differs in Qlik sense

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...,   .... )

 

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein