Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

Sum calculation

Hi

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.

1 Solution

Accepted Solutions
montubhardwaj
Valued Contributor

Sum calculation

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

1 Reply
montubhardwaj
Valued Contributor

Sum calculation

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