How to only show 'PIN' and 'NRP' as distributor in PIVOT Table.

[suvechha_b]

Hi All ,

How to only show 'PIN' and 'NRP' as distributor in PIVOT Table.

The chart should only reflect distributor - 'PIN' and 'NRP'.

No need to should 'ASPEN' IHS' etc.

The Chart

sample attached.

[sunny_talwar · Accepted solution]

May be use a calculated dimension like this

=If(Match(distributor, 'PIN', 'NRP'), distributor)

or set analysis like this

{<distributor = {'PIN', 'NRP'}>}

Attaching a calculated dimension way of doing it

[suvechha_b]

Hi Sunny ,

It is working. But Please kindly check why the "Prev 3 months Sale Units" is not working.

Thanks,

[sunny_talwar]

Is this a new question? Not sure where this came from and where to find it?

[suvechha_b]

Same sample model.

The "Prev 3 months Sale Units" is calculating.

Previously I only filtered distributor - 'PIN' and 'NRP' refer to qlikview script distributor_link.

But when I remove that as it was having issue with the stock is allocating to NULL distributor . though it should link with 'PIN'.

why this is happening in my qlikview script when I am using distributor_link.

When I tried to remove the distributor_link.script from Qlikview.

The set analysis is not working. - "Prev 3 months Sale Units".

Please assist.

Thanks,

[suvechha_b]

Hi Sunny ,

I used this expression in my dimension .

=If(Match(distributor, 'PIN', 'NRP'), distributor)

But when I am trying to select the distributor - it is not selecting Say - I only want to see the "NRP" Distributor.

[sunny_talwar]

Strangely enough you already were using the set analysis solution in some of your expressions... either remove them or change them to this distributor *= {'NRP','PIN'}... you only need to use set analysis or calculated dimension.... feel free to remove the other thing....

[suvechha_b]

It is working 100 %. Thank you very much.