topic Hide Dimensions in Pivot table in QlikView

Hide Dimensions in Pivot table

tyagishaila — Tue, 07 Jul 2015 06:27:06 GMT

Hi All,

How can we hide dimensions in pivot table?

Thanks,

Re: Hide Dimensions in Pivot table

Chanty4u — Tue, 07 Jul 2015 06:32:19 GMT

Hi,

PFA

hope this helps you

Thanks,

Chanty

Re: Hide Dimensions in Pivot table

Chanty4u — Tue, 07 Jul 2015 06:35:12 GMT

Hi,

chk below link as well

https://community.qlik.com/docs/DOC-6046

thank you

Chanty

Re: Hide Dimensions in Pivot table

jagan — Tue, 07 Jul 2015 06:36:45 GMT

Hi,

You can hide a dimension conditionally by using the

Chart Properties-> Dimension-> Enable Conditional option.

Check this link

Adhoc reporting in Qlikview

Regards,

Jagan.

Re: Hide Dimensions in Pivot table

Chanty4u — Tue, 07 Jul 2015 06:47:07 GMT

Hi tyagish,

If get the exact information make it as correct answer.bcz it wil helps you while finding anyone on dis.

Thanks,

Chanty

Re: Hide Dimensions in Pivot table

tyagishaila — Tue, 07 Jul 2015 06:47:34 GMT

Hi Jagan Mohan,

Thanks for quick reply But Adhoc Reporting.qvw is working for Straight table.

And I want to hide dimensions in pivot table.

Please help me.

Thanks,

Re: Hide Dimensions in Pivot table

tyagishaila — Tue, 07 Jul 2015 06:49:53 GMT

Hi Suri qv,

Thanks for quick reply,

Can we have any solution other then Macros?

Any statement in Enable condition or layout condition etc..

If yes please help me.

Thanks,

Re: Hide Dimensions in Pivot table

Chanty4u — Tue, 07 Jul 2015 06:53:32 GMT

hi,

PFA

Re: Hide Dimensions in Pivot table

Tue, 07 Jul 2015 06:55:50 GMT

Hi Tya,

You can hide dimension using object properties. Like this way

Chart - > Properties -> Dimension -> enable condition option -> write code which dimension you need hide.

Hope it will help you.

Ramya.

Re: Hide Dimensions in Pivot table

tyagishaila — Tue, 07 Jul 2015 06:58:40 GMT

HI,

I have 6 tables/ Pivot Charts on my dashboard, I am sending all pivot charts together into excel by using macro.

Now on excel sheet, i want to show dimensions only once, i.e. only one chart(1st chart) should shows its dimensions, rest show only expressions.

Thanks,

Re: Hide Dimensions in Pivot table

tyagishaila — Tue, 07 Jul 2015 06:59:55 GMT

Hi ramya,

Thanks for reply

Which code should I write?

Thanks,

Re: Hide Dimensions in Pivot table

Tue, 07 Jul 2015 07:05:23 GMT

Hi tya,

Kindly downlaod that file and explore it and do r & d, you will know that where i written the code in dimension hiding.

Ramya.

Re: Hide Dimensions in Pivot table

tyagishaila — Tue, 07 Jul 2015 07:12:02 GMT

Thanks Ramya ,

its working

but as dimension hides, its Total also hide with it.

So I have to search another way to send charts into excel.

ThankYou

Re: Hide Dimensions in Pivot table

Tue, 07 Jul 2015 07:13:39 GMT

Hello,

it's simple right just try that code with your own way u will get.

Ramya.

Re: Hide Dimensions in Pivot table

Tue, 07 Jul 2015 07:17:18 GMT

It depends on which situation you want to hide your dimesion.

Re: Hide Dimensions in Pivot table

jagan — Tue, 07 Jul 2015 07:24:41 GMT

Hi,

The same works for Pivot table also just convert Straight table to Pivot table.

Regards,

Jagan.