Hide Dimensions in Pivot table

[tyagishaila]

Hi All,

How can we hide dimensions in pivot table?

Thanks,

[Chanty4u]

Hi,

PFA

hope this helps you

Thanks,

Chanty

[Chanty4u]

Hi,

chk below link as well

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

thank you

Chanty

[jagan]

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.

[Chanty4u]

Hi tyagish,

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

Thanks,

Chanty

[tyagishaila]

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,

[tyagishaila]

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,

[Chanty4u · Accepted solution]

hi,

PFA

[#9]

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.

[tyagishaila]

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,