topic Re: Pivot table Hide measure column based on dimension value? in QlikView

Pivot table Hide measure column based on dimension value?

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

Hi,

In Pivot table, Is there any way to hide measure based on one dimension value?

Please refer to the attachment,

Example, if Outlet is WH then need to show only SOH measure (based on dimension value need to hide specific measure in pivot table)

Note: i don't want to use macros option.

Thanks, Dev

Re: Pivot table Hide measure column based on dimension value?

sunny_talwar — Fri, 27 Jan 2017 12:39:07 GMT

This?

Re: Pivot table Hide measure column based on dimension value?

sunny_talwar — Fri, 27 Jan 2017 12:40:42 GMT

I also want to thank you for consistently sharing samples with your post. A lot of the times people don't share a sample making our job so much more difficult. From all the people I try to help, I love those who provide most of the details. Input, output and qvw.

Once again thanks for doing this and continue the good work.

Best,

Sunny

Re: Pivot table Hide measure column based on dimension value?

rahulpawarb — Fri, 27 Jan 2017 13:18:04 GMT

Simple and Effective (As always!)

Re: Pivot table Hide measure column based on dimension value?

devarasu07 — Mon, 06 Mar 2017 14:30:15 GMT

Hi stalwar1‌

In my case, i've more than outlet(exactly30 outlets) and one warehouse so tried to updated the if conditional and it's not giving expected result. do you have any idea? Thanks

Tried with below expression

=Pick(Dim, If(Outlet = 'T2' or Outlet= 'T3', 'Sold Qty'), 'SOH')

//=Pick(Dim, If(Outlet = 'T2', 'Sold Qty'), 'SOH')

Thanks,

Deva

Re: Pivot table Hide measure column based on dimension value?

sunny_talwar — Mon, 06 Mar 2017 14:37:48 GMT

Would you be able to point out what the expected output needs to look like?

Re: Pivot table Hide measure column based on dimension value?

devarasu07 — Mon, 06 Mar 2017 16:32:07 GMT

Hi stalwar1‌

by using below expression getting correct result but instead of Measure Column header it's shows number (dim table values). how to change below highlighted numbers to "Sold Qty" for all outlets expected CKS-WHS(only SOH measure)

=Pick(Dim, Match(Outlet, 'ION','313','NEX','CWP','CTL','MBS','T2','T3', 'Sold Qty'), 'SOH')

and also need to show Total at the right side(all stores total by each materiel).

Thanks,

Deva

Re: Pivot table Hide measure column based on dimension value?

sunny_talwar — Mon, 06 Mar 2017 16:52:45 GMT

Which total are you looking to get? Both Sold Qty and SOH?

=Pick(Dim, If(Match(Outlet, 'ION','313','NEX','CWP','CTL','MBS','T2','T3'), 'Sold Qty'), 'SOH')

Re: Pivot table Hide measure column based on dimension value?

devarasu07 — Mon, 06 Mar 2017 16:55:51 GMT

Hi Sunny,

Thanks, Yeah looking for both Sold Qty and SOH total at end.

Thanks,Deva

Re: Pivot table Hide measure column based on dimension value?

sunny_talwar — Mon, 06 Mar 2017 17:02:45 GMT

May be this

Re: Pivot table Hide measure column based on dimension value?

devarasu07 — Mon, 06 Mar 2017 17:06:39 GMT

Hi stalwar1‌,

Perfect. It's working like a charm. Thanks

Regards,

Deva