topic Check if excel cell is blank before loading in qlikview in QlikView

Check if excel cell is blank before loading in qlikview

Wed, 25 Jan 2017 08:47:11 GMT

I have this field called LEVEL3. Basically some of them contain values and some do not. I only want to load those that contain values and therefore as you can see the code below, I have the logical operator AND LEVEL <> ' '. However, this does not work. How do I go about doing this?

IF(LEVEL2 = '16.29', LEVEL2, IF(LEVEL2 = '16.31', LEVEL2, IF(LEVEL2 = '16.30' AND LEVEL3 <> ' ', LEVEL2, LEVEL1))) AS LEVEL4,

Re: Check if excel cell is blank before loading in qlikview

m_s — Wed, 25 Jan 2017 09:01:53 GMT

Assuming your IF-Statement is correct, have you tried Len(Trim(FIELD)) > 0?

IF(LEVEL2 = '16.29', LEVEL2, IF(LEVEL2 = '16.31', LEVEL2, IF(LEVEL2 = '16.30' AND LEN(TRIM(LEVEL3)) > 0 , LEVEL2, LEVEL1))) AS LEVEL4,

Re: Check if excel cell is blank before loading in qlikview

stabben23 — Wed, 25 Jan 2017 09:43:32 GMT

Hi,

try With this:

IF(LEVEL2 = '16.29', LEVEL2, IF(LEVEL2 = '16.31', LEVEL2, IF(LEVEL2 = '16.30' AND (len(LEVEL3 > '0 '), LEVEL2, LEVEL1))) AS LEVEL4,

Re: Check if excel cell is blank before loading in qlikview

avinashelite — Wed, 25 Jan 2017 09:46:26 GMT

if you want to reduce the data then directly add a condition in the script

where

len(Trim(LEVEL))>0