topic Re: Need a pivot chart without + or - simbol in QlikView

Need a pivot chart without + or - simbol

Wed, 25 Nov 2020 16:16:04 GMT

Hi,

I need to create a pivot chart where in we do not need to show the + and - symbols only hierarchy indentation should be maintained.

With no expand or collapse behavior as we just need a default view.

For example

World

Asia

India

North

South

East

West

Pakistan

Srilanka

China

Europe

Germany

France

Rest of Europe

America

North America

South America

For above pivot chart we dont want any further expansion or collapse.

I have attached one example of pivot chart.

Please advise

Thanks

Abdul

Re: Need a pivot chart without + or - simbol

sunny_talwar — Wed, 05 Oct 2016 16:08:42 GMT

Looking to get this?

1) Check 'Indent Mode' on Style tab

2) Check 'Always Full Expanded' on the presentation tab

Re: Need a pivot chart without + or - simbol

Thu, 06 Oct 2016 07:03:00 GMT

Hi Sunny,

Thanks for your quick reply.

But Actually I don't want to expand all node. actually I want to expand only few nodes and rest of them non Expanded.

Rest of the view is fine as I dont get + and -.

Thanks in Advance

Amit

Re: Need a pivot chart without + or - simbol

sunny_talwar — Thu, 06 Oct 2016 16:30:50 GMT

Unfortunately there is no way to selectively show + and - signs for each of the hierarchies. You either see them for all, or you don't see at all. I am not sure if there is a Macro or extension available which might address this concern, but personally, I have never seen anybody being able to resolve this issue

Best,

Sunny

Re: Need a pivot chart without + or - simbol

Fri, 07 Oct 2016 09:28:47 GMT

Thanks Sunny.

Can you please do me a small favour.

I need to export image of my chart with Header labels applied so do you have any macro code or something like this.

Thanks

Abdul