topic Not to display a value in a chart in QlikView

Not to display a value in a chart

Thu, 28 Jun 2012 07:05:40 GMT

Hi All,

I have attached a sample qv applicaion. In this application i have created a chart using vendor name as dimension and month as expression. The vendor name will have list of names. In the chart it should not show the vendor name("Anand","Mark").

How can i do this in chart level. Please provide a solution.

Regards,

Gerard

Re: Not to display a value in a chart

deepakk — Thu, 28 Jun 2012 07:11:00 GMT

Hi,

PLease find the solution in the attachment.

Deepak

Re: Not to display a value in a chart

Thu, 28 Jun 2012 09:01:09 GMT

Hi Deepak,

Thanks for the solution. Its working fine. Instead of giving it in the expression, is there any way to give it in dimension. Since if we pull vendor name as a list box and we select "Anand" " Mark", the graph will show the vendor name with months 0. Is there any way to remove the name from the chart.

Regards,

Gerard

Re: Not to display a value in a chart

deepakk — Thu, 28 Jun 2012 09:10:12 GMT

HI gerard,

You mean to say you don't want to load that data. If that the case then you have to filter at script.

Load * from table where VendorName <> 'Anand' or VendorName <> 'Mark'

if you wnat you can also filter at the dimension of a chart,

Go to Dimension --> Add Caluclated DImension --> If (VendorName <> 'Anand' or VendorName <> 'Mark',VendorName)

Below you will find a check box for suppress nulll value. Enable it.

Deepak