topic Re: Pick function not working in charts in QlikView

Pick function not working in charts

Wed, 25 Nov 2020 16:16:04 GMT

Hi Team,

I have requirement to use Pick function in charts. But when I am using it suppress zero is not working. Please check the attached example and let me know if something can be done to remove others from legend i.e zero values should not be displayed.

Regards,

Sai Krishna.

Re: Pick function not working in charts

sunny_talwar — Wed, 28 Dec 2016 11:44:22 GMT

Is this what you want?

uncheck 'Show Others' on the Dimension Limits Tab

Re: Pick function not working in charts

Wed, 28 Dec 2016 15:41:45 GMT

We need to show others as in real data there are more managers and we have to show only top 5 and others.

Re: Pick function not working in charts

sunny_talwar — Wed, 28 Dec 2016 15:52:36 GMT

So the 0 we were seeing here was associated with others. If for your real data you don't have 0 for others, I don't think you should have any problem. Would you be able to share a sample where others is not 0 and you still see 0?

Re: Pick function not working in charts

Thu, 02 Mar 2017 11:34:41 GMT

Raised this issue with Qlik team. They agreed that this is a bug. They are not ready to resolve now as it affect many other areas.

When many other customers requires this fix then they may take up the issue.