Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Support Cases coming to Qlik Community Oct. 4! Start chats, open cases, explore resources: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
Applicable88
Creator III
Creator III

If and Set-analysist not same results

Hello,

i have following expression within my bar-chart:

count({$<[ Code]={"R350","R630","W510","W630"}>}Report)

Why I don't get any results with this if -statement:

=if(match([ Code], 'R350','R630','W510','W630'),(Report))

I tried wildmatch also. Not a single value showing in the chart.

Tried that as well:

if(match([ Code], 'R350','R630','W510','W630'), count (Report))

Thanks in advance.

Best

 

1 Solution

Accepted Solutions
lironbaram
Partner
Partner

hi 

you should have the expression like this 

count(if(match([ Code], 'R350','R630','W510','W630')>0,(Report)))

View solution in original post

1 Reply
lironbaram
Partner
Partner

hi 

you should have the expression like this 

count(if(match([ Code], 'R350','R630','W510','W630')>0,(Report)))

View solution in original post