Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

aviadbein
New Contributor II

Re: Challenging Condition/Formula

Great man! it's seems to be working.

one more question: Now, if I want to display the data on a bar chart and set the colors  with expression

I can't use: Pick(match('GOOD','BAD'),green(),red()) because i don't have a field name in the Match() func. so what can I do in order to color the 'GOOD'/'BAD' bars?

Highlighted
MVP
MVP

Re: Challenging Condition/Formula

did you try color by expression with this expression

=If(Aggr(Count(DISTINCT {<Girlfriend = {0}, Distance = {'<=5'}>} Boy), Date, Boy) = 1, Red(), Green())

Capture.PNG

aviadbein
New Contributor II

Re: Challenging Condition/Formula

Yes, I solved it like you. It works!

Thanks a lot for all your help!

MVP
MVP

Re: Challenging Condition/Formula

Awesome!!

Please consider marking any helpful responses from this thread so that it can help future visitors to this thread.

Best,

Sunny