Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

Removing (-VE) and 0 Sales Amount & Quantity

Hello there folks,

I was just wondering - how I can go about removing and 0 values from a report?

End user has complained that, the and 0 results have been interfering with the average price calculation. They do have a point there, it is no longer accurate.

I tried this if-statement in the expression, if ( A > 0, A), it only substitutes the amount rows with a dash, but the total sales amount didn't change it remains the same as before the statement was included.

Please advise. Thanks in advance.

Best Regards,

Ram

6 Replies
Employee
Employee

Re: Removing (-VE) and 0 Sales Amount & Quantity

In the load script you could have a flag indicating if the value is positive.

E.g.

Load

     *,

     If(revenue>0,1,0) as _FlagPositiveFacts,

     revenue

From

....

then in your charts you could have set analysis to only include facts where _FlagPositiveFacts =1

Not applicable

Re: Removing (-VE) and 0 Sales Amount & Quantity

Hi Damian,

Thanks for your suggestion.

Just curious, if I was reluctant to do any modification in the load script. Is it possible to do this in the report expression?

What am trying to say is, if there is some other work around?

Thanks in advance, mate!

Employee
Employee

Re: Removing (-VE) and 0 Sales Amount & Quantity

Hmm not too sure. As this is average you want to exclude the line items from the possible data set. I can only think of this via a filter which is set analysis. However would be interested to be informed otherwise.

MVP
MVP

Re: Removing (-VE) and 0 Sales Amount & Quantity

I guess proper use of IF or set analysis could help you. Can you explain your issue with an example or post a sample app?

Not applicable

Re: Removing (-VE) and 0 Sales Amount & Quantity

Thanks anyway. I have already figured it out.

Not applicable

Re: Removing (-VE) and 0 Sales Amount & Quantity

Thanks anyway. I have already figured it out.

Community Browser