Not to display a value in a chart

[#1]

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

[deepakk · Accepted solution]

Hi,

PLease find the solution in the attachment.

Deepak

[#3]

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

[deepakk]

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