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

[karthikoffi27se]

Hi Aaron,

use the below formula in the conditional tab and Sum(Sales) in a your expression tab

Substringcount(Concat ([Product Sub Group],'|'),'Cheese')

Many Thanks

Karthik

[aaronnayan]

Sorry this is for Qlik sense right?

[karthikoffi27se]

No this is for QlikView

[jonathandienst]

Set a chart calculation condition:

=GetSelectedCount([Product Sub Group])

[aaronnayan]

Thats sort of correct

But how to make it populate when i select  the value cheese?

[OmarBenSalem]

try:

if( GetFieldSelections([Product Sub Group])=,'Cheese',sum(Sales),0)

[aaronnayan]

That does not work

[aaronnayan]

Okay Guys

Still not working

How would i write this

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

another

if(GetSelectedCount({<[Tshirt]>}={'Black'}>}

I only want the chart to populate if the defined value is selected?

As a calculated condition

Thankyou

[OmarBenSalem]

you have a "," before cheese..

what if u elminate it?