topic Re: IF AND in QlikView

IF AND

stekol61 — Wed, 25 Nov 2020 16:16:04 GMT

I have a QV app with a Text field.

I want to change the font color based on a filter.

If i select the filter 'Technology' as '1' or '2' or '3' the color should be green.

If i select '1' AND '2' it should be red

I used this expression bet it doesn't work (shows green no matter what filter value I use)

=If (Technology='1' and Technology='2' , v_rgb_red, v_rgb_green)

Re: IF AND

sunny_talwar — Fri, 18 Sep 2020 13:25:54 GMT

Try this instead

=If(Concat(Technology, '|'), = '1|2', v_rgb_red, v_rgb_green)

Re: IF AND

stekol61 — Fri, 18 Sep 2020 13:52:29 GMT

Hi!

I get 'Error in expression'

I wrote '1' and '2' but it should be '1G' and '2G'. Don't know if it matters.

Re: IF AND

Kushal_Chawda — Fri, 18 Sep 2020 14:03:53 GMT

@stekol61... try below. there was a typo

=If(Concat(Technology, '|') = '1G|2G', red(), green())

Re: IF AND

stekol61 — Fri, 18 Sep 2020 14:10:50 GMT

No error but the color is always green, no matter if I select 1G or 2G or both

Re: IF AND

sunny_talwar — Fri, 18 Sep 2020 14:30:15 GMT

Would you be able to share an image to show what you are seeing?

Re: IF AND

stekol61 — Fri, 18 Sep 2020 14:36:51 GMT

See image below:

Re: IF AND

sunny_talwar — Fri, 18 Sep 2020 14:38:54 GMT

But does it turn red when both 1G and 2G are selected? Are you also looking for it to turn red when 1G or 2G was selected? When will it show Green? Only if 3G was selected with or without 1G and/or 2G?

Re: IF AND

Kushal_Chawda — Fri, 18 Sep 2020 14:39:01 GMT

@stekol61 may be you have multiple occurrence of value so try with distinct and below condition

=if(GetSelectedCount(Technology)>1, if(concat(distinct Technology,'|')='1G|2G',red(), if(concat(distinct Technology,'|')='1G|2G|3G',green())))

Re: IF AND

stekol61 — Fri, 18 Sep 2020 14:45:40 GMT

Better now.

It should be green if 2G, 3G and 4G is selected and this works

Any other selection should be red

Re: IF AND

sunny_talwar — Fri, 18 Sep 2020 14:55:09 GMT

So, all 3 selected together it should be green? If only 3G is selected? or 3G and 4G selected?

Re: IF AND

stekol61 — Fri, 18 Sep 2020 14:59:01 GMT

Yes, only 2G, 3G and 4G should be green.

Single value or any other combination, e.g 3G and 4G, should be red

Re: IF AND

sunny_talwar — Fri, 18 Sep 2020 15:31:23 GMT

So, then try this

If(Concat(DISTINCT Technology, '|') = '2G|3G|4G', Green(), Red())

Re: IF AND

Kushal_Chawda — Fri, 18 Sep 2020 20:27:26 GMT

@stekol61 Just another option in case your field is not sorted and concat values sequence does not match with hard coded value then for safer side check condition for individual values so that it will work always

=if(wildmatch(GetFieldSelections(Technology),'*2G*') and wildmatch(GetFieldSelections(Technology),'*3G*') and wildmatch(GetFieldSelections(Technology),'*4G*') ,green(),red())

Re: IF AND

stekol61 — Mon, 21 Sep 2020 09:01:28 GMT

THX, this solved my problem

Re: IF AND

sunny_talwar — Mon, 21 Sep 2020 11:52:04 GMT

@Kushal_Chawda why not add a sort parameter for this instead? Have not tested it, but the idea is to give a sort for the Concat function.

If(Concat(DISTINCT Technology, '|', -Rank(Technology)) = '2G|3G|4G', Green(), Red())

Re: IF AND

Kushal_Chawda — Mon, 21 Sep 2020 11:56:59 GMT

@sunny_talwar Yes. We can give it. I just used another method instead without depending on the sorting.