topic Re: if statement problem in QlikView

if statement problem

Wed, 15 Oct 2014 10:13:24 GMT

Hello to all of you,

i have a problem. I want to check if two numbers are available in my table when i selected my Sell Nr.

The if statement doesn't work and i don't know why.

Here are the Statement:

if((NR=123456 and NR=7891011),'Yes','No')

For the selected Sell Nr there are both number (NR) available, so it should be on "Yes" and not of "No".

What is my mistake?

Kind Regards

Re: if statement problem

alexandros17 — Wed, 15 Oct 2014 10:21:53 GMT

You used AND but the condition is OR ... try and let me know

Re: if statement problem

anbu1984 — Wed, 15 Oct 2014 10:22:05 GMT

When you select one NR, other NR is not available. So you didnt result

Can you explain with source data what are you trying to do?

Re: if statement problem

tresB — Wed, 15 Oct 2014 10:29:43 GMT

In a text box:

=If(Index(Concat(DISTINCT NR), '123456') And Index(Concat(DISTINCT NR), '7891011'), 'Yes', 'No')

Re: if statement problem

Wed, 15 Oct 2014 10:32:44 GMT

Hello,

i have a table (head) that call "Sell" there is a Sell Nr. Then i have a table with the details "Sell details".

The both tables are linked over the SellNr. In the "Sell details" are two lines and so i have in the column "NR" two numbers. But i only want to calculate when both numbers are in the "Sell details". So i want to say, only when the numbers are in this, then you have to do.... I only have test it with Yes or No to prove if this are in the table.

Re: if statement problem

anbu1984 — Wed, 15 Oct 2014 10:35:23 GMT

Can you post sample data