topic Re: Multiple Selection Criteria for displaying a value in App Development

Multiple Selection Criteria for displaying a value

RThakore — Fri, 27 Oct 2023 15:21:31 GMT

Question about Qlik sense expressions: Multiple Selection Criteria for displaying a value

Condition #1: #If F1_Char in ('0','3'), F2_Char = A and F3_Char in ('1','5') show the value of Column F4 on the report

Condition #2: #If F1_Char in ('0','3') and F2_Char = A and F3_Char NOT IN ('1','5') show NULL INSTEAD OF value of F4 on the report
**************************************************************

I want to be able to display the column value for F4 on the report for all cases except when the "Conditon #2" is true. Will something like the following work?

Or will it exclude other values of F1_Char and F2_Char and F3_Char where I do want to show the value of F4

=if( F2_Char='A' and match(F1_Char, 0, 3) and match( F3_Char, 1, 5), F4)

***************************************************************
DATA:
F1_Char F2_Char F3_Char Display(F4)
0 A 1 Yes
0 A 5 Yes
3 A 1 Yes
3 A 5 Yes
0 A <>1 No
0 A <>5 No
3 A <>1 No
3 A <>1 No

Re: Multiple Selection Criteria for displaying a value

HeshamKhja1 — Mon, 30 Oct 2023 07:24:43 GMT

Hi @RThakore ,

No, it should not exclude the values from F1_Char and F2_Char and F3_Char. It should only affect column F4.

Did you try it? the best way to know is to actually try and see what happens. Then if you are unable to achieve your desired output, ask how to achieve it.

Re: Multiple Selection Criteria for displaying a value

RThakore — Mon, 30 Oct 2023 16:00:00 GMT

Yes I tried it. Thanks for your response