Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
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.
Yes I tried it. Thanks for your response