topic Re: How to only show 'PIN' and 'NRP' as distributor in PIVOT Table. in QlikView

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

suvechha_b — Wed, 25 Nov 2020 16:16:04 GMT

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.

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

sunny_talwar — Mon, 05 Jun 2017 11:47:46 GMT

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

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

suvechha_b — Mon, 05 Jun 2017 11:52:25 GMT

Hi Sunny ,

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

Thanks,

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

sunny_talwar — Mon, 05 Jun 2017 11:54:22 GMT

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

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

suvechha_b — Mon, 05 Jun 2017 12:12:04 GMT

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,

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

suvechha_b — Tue, 06 Jun 2017 06:35:44 GMT

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.

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

sunny_talwar — Tue, 06 Jun 2017 09:28:04 GMT

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

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

suvechha_b — Tue, 06 Jun 2017 09:53:20 GMT

It is working 100 %. Thank you very much.