Sum calculation

Wed, 25 Aug 2010 09:26:09 GMT

1. I currently have a bar chart which drills down into my various options. I am looking to display only Operations_scrapped. My chart is set up when I go to the properties, expression tab, in the definition box I was the following statement:

NumericCount (Scrapped_Operations). This does not work as it shows me all the operations and not just the scrapped ones. Can someone help me with the expression I need to use.

Thanks.

Sum calculation

montubhardwaj — Wed, 25 Aug 2010 10:58:22 GMT

Hi Kelley,

In the expression, you can try filtering the results only for "Scraped" ones.You can use IF,ELSE condition something like this.

= Count(IF(<Your Field> ='Scraped',<Your Field>))

Hope this was helpful.

Regards,

Dinesh Sharma

topic Sum calculation in QlikView

Sum calculation

Sum calculation