Calulcated condition QlikSense!!!!!!!!!!!!!!!!!!!!!

[aaronnayan]

Hi Guys

Trying to write a formula

Could you correct this?

if(GetSelectedCount({<[Product Sub Group]>}={'Cheese'}>}[Sales]))

I only want the chart to populate if cheese is selected

Thankyou

[aaronnayan]

In the calculated condition

if( [Product Sub Group] = 'Cheese', -1, 0 )

[sunny_talwar]

So, right now since nothing is selected, the expression doesn't show anything... isn't that what you want? Or would you want to see Cheese even if nothing is selected? For this you can try this

Sum({<[Product Sub Group] *= {'Cheese'}>}[Sales Amount])

[aaronnayan]

I want the chart to show me the count of sales only when cheese the value is selected, but when it is not it shows all values

[sunny_talwar]

So if Cheese and Beer is selected... it should not show anything?

If([Product Sub Group] = 'Cheese', Sum([Sales Amount]))

[mdmukramali]

Hi,

Maybe like this:

If([Product Sub Group] = 'Cheese', Sum([Sales Amount]),Sum({1}[Sales Amount]))