topic Re: IF function to look for specific value in multiple values/multiple line table in QlikView

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

Thu, 30 Oct 2014 13:21:54 GMT

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!

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

Gysbert_Wassenaar — Thu, 30 Oct 2014 13:37:41 GMT

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.

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

Tue, 04 Nov 2014 15:53:52 GMT

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!