Qlik Community

Ask a Question

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
Qlik Highlights 2020 Giveaway! Watch, reply and have a chance to win a $200 Amazon Gift Card! Watch Video
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

IF function to look for specific value in multiple values/multiple line table

Hi all

I have two tables, linked by an SKU field. Both tables have multiple lines per SKU.

I created a pivot chart with fields coming just from table A.

I am trying to create an expression that if there is at least one entry equal to "check" in field "criteria" of table B , it shows "check"

but since there is several values in table B for each SKU, which might be either "check" or "to be checked", I end up with unreliable results.

What I am using is:

if(criteria='check','check')

but indeed is giving unreliable results.

Any suggestion?

thanks!

1 Solution

Accepted Solutions
MVP & Luminary
MVP & Luminary

Maybe something like this: if(count({<criteria={'check'}>}SKU),'check'). If that doesn't work you'll have to post a document that demonstrates the problem.


talk is cheap, supply exceeds demand

View solution in original post

2 Replies
MVP & Luminary
MVP & Luminary

Maybe something like this: if(count({<criteria={'check'}>}SKU),'check'). If that doesn't work you'll have to post a document that demonstrates the problem.


talk is cheap, supply exceeds demand

View solution in original post

Not applicable

Hey Gysbert!

Indeed on a sample I created it was working perfectly.

But on the real data it wasn't and had me occupied for sometime; until I realised I was using the wrong bracket!

thanks!