topic Removing Data from Qlikview in QlikView

Removing Data from Qlikview

Tue, 29 Nov 2011 12:36:05 GMT

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

Removing Data from Qlikview

Anonymous — Tue, 29 Nov 2011 12:41:24 GMT

What if you try:

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

Removing Data from Qlikview

Tue, 29 Nov 2011 12:43:04 GMT

Hi Dennis,

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

Removing Data from Qlikview

Anonymous — Tue, 29 Nov 2011 12:58:53 GMT

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

Removing Data from Qlikview

Tue, 29 Nov 2011 13:06:50 GMT

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

Removing Data from Qlikview

Anonymous — Tue, 29 Nov 2011 13:18:52 GMT

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

Something like:

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

Removing Data from Qlikview

Tue, 29 Nov 2011 13:51:56 GMT

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