Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

aaronnayan
Contributor

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

24 Replies
karthikoffi27se
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

aaronnayan
Contributor

Re: Calulcated condition

Sorry this is for Qlik sense right?

karthikoffi27se
Contributor III

Re: Calulcated condition

No this is for QlikView

MVP
MVP

Re: Calulcated condition

Set a chart calculation condition:

=GetSelectedCount([Product Sub Group])

aaronnayan
Contributor

Re: Calulcated condition

Thats sort of correct

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

omarbensalem
Esteemed Contributor

Re: Calulcated condition

try:

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

aaronnayan
Contributor

Re: Calulcated condition

That does not workqliikk community.PNG

aaronnayan
Contributor

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

omarbensalem
Esteemed Contributor

Re: Calulcated condition

you have a "," before cheese..

what if u elminate it?

Capture.PNG