# New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Highlighted
Contributor III

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

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

Tags (7)
24 Replies
Contributor III

## Re: Calulcated condition

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

Contributor III

## Re: Calulcated condition

Sorry this is for Qlik sense right?

Contributor III

## Re: Calulcated condition

No this is for QlikView

MVP

## Re: Calulcated condition

Set a chart calculation condition:

=GetSelectedCount([Product Sub Group])

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
Contributor III

## Re: Calulcated condition

Thats sort of correct

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

Partner

## Re: Calulcated condition

try:

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

Contributor III

## Re: Calulcated condition

That does not work

Contributor III

## Re: Calulcated condition

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

Partner

## Re: Calulcated condition

you have a "," before cheese..

what if u elminate it?