# New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

cancel
Showing results for
Did you mean:
Creator 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 (2)

• ### SaaS

1 Solution

Accepted Solutions
Partner

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

Dim1:

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
Luminary Alumni

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

Partner

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

Dim1:

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