# New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Highlighted
New Contributor III

## Pivot Table Column value differs in Qlik sense

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.

Labels (10)

• ### qliksense desktop

1 Solution

Accepted Solutions 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
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

## 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