topic Re: If statement in QlikView

If statement

Thu, 03 Dec 2015 12:15:44 GMT

This if statement is not working.

I am not getting an error, but it is not returning the values I am expecting.

if(ACCNUM = '1US002', (if( HUB = 'CPT' , 'USC'))) ,

Anonymous — Thu, 03 Dec 2015 12:36:41 GMT

try this:

if(ACCNUM = '1US002' or HUB = 'CPT' , 'USC')

ganeshreddy — Thu, 03 Dec 2015 12:39:19 GMT

May be try this

if(ACCNUM = '1US002', if( HUB = 'CPT' , 'USC','No Data'),'No Data') ,

maxgro — Thu, 03 Dec 2015 12:46:09 GMT

if(ACCNUM = '1US002' and HUB = 'CPT' , 'USC', 'boh')

sunny_talwar — Thu, 03 Dec 2015 13:12:53 GMT

What are you seeing and what do you expect to see?

effinty2112 — Fri, 04 Dec 2015 11:19:52 GMT

Hi Robyn,

Your expression boils down to this:

if(CCNUM = '1US002' and HUB = 'CPT', 'USC')

which may be easier to read and figure out what's going on.

Cheers