Removing Data from Qlikview

[#1]

Hi,

I have a excel document called Software and one of the sheet is called Summary. In the Summary section I have entered the data, Oracle, Password Reset, Cyborg and Other.  The Pie chart that I created shows all these values, however I want to remove Password Reset from the pie chart, so the pie chart only shows, Oracle, Cyborg and Other. 

I tried using the below code in my expression editor in the dimension section, but I get a Error in Expression.

=IF(Software.Software='Password Reset',IsNull(),[Software.Software])

Does anyone know how I can do this please?

Jon Ditchfield

[Anonymous]

What if you try:

=IF(Software.Software='Password Reset',0,[Software.Software])

?

[#3]

Hi Dennis,

The Password Reset values changes into a 0 but the data still shows on the pie chart.

[Anonymous]

Also if you check "Supress Zero-Values" op the presentation tab?

[#5]

The data in the ledgend still shows as a 0 instead of password reset, but the value still shows on the pie chart. 

[Anonymous · Accepted solution]

Sorry missread, the formula should not be in the dimension but in your expression

Something like:

=IF(Software.Software='Password Reset',0,Sum(Value))

[#7]

Dennis you are an absolute ledgend thanks for your help it worked wonders.