topic true/false expression help needed in QlikView

true/false expression help needed

Thu, 10 Jul 2014 16:05:04 GMT

Can someone help me with a true/false expression? I need a field that gives me a Y or N.

I have some products and if it equals a certain value/text, I want it to say yes and if not, N.

For example:

If coffee = 4 then I want the field to say Y

If coffee do not equal 4, then I want the field to say N

If tea = 'Rare' then Y

If tea does not equal 'Rare" then N

I am very new to QV. Thanks in advance.

jerem1234 — Thu, 10 Jul 2014 16:10:43 GMT

Use an if statement like:

if(Coffee =4, 'Y', 'N')

if(Tea = 'Rare', 'Y', 'N')

Hope this helps!

Thu, 10 Jul 2014 16:14:49 GMT

Thanks!!