Showing a barchart with conditions

[pontus1974]

Hi,

I would like to sum all products='banana' and show as a barchart.

Where do I put the if condition:  sum (product='banana')

Regards

Nils

[sunny_talwar]

May be like this

Count({<product = {'banana'}>} product)

[dberkesacn]

Or you also can restrict the dimension with a calculated one if(desc='banana',desc,null()) and click on suppress when value is null

[pontus1974]

Thanks for the solutions. It is working perfectly

[sunny_talwar]

Great, please close the thread by marking correct and helpful responses.

Qlik Community Tip: Marking Replies as Correct or Helpful

Best,

Sunny