topic Re: is null in QlikView

is null

raadwiptec — Wed, 25 Nov 2020 16:16:04 GMT

my table looks like below

rep ID |column name | column value | total value

10002 sales region france 100

10004 sales teritory | le pont | 200

10002 sales office avenue ,3 | 300

10004 sales region italy | 160

10002 sales office | 300

now i need a condition in the script

if |column name is sales region and the value of sales office is blank or null ) as a [sales reps france]

Re: is null

Anil_Babu_Samineni — Mon, 18 Dec 2017 10:18:28 GMT

May be this?

If([column name] = 'sales region' and IsNull([column value]), 1,0) as [sales reps france]

Re: is null

its_anandrjs — Mon, 18 Dec 2017 10:19:17 GMT

Check some of this

NULL handling in QlikView

how to handle null values in qlikview

Re: is null

its_anandrjs — Mon, 18 Dec 2017 10:23:59 GMT

How you are checking sales region and the sales office in same column, please elaborate more.

Re: is null

zhadrakas — Mon, 18 Dec 2017 10:27:35 GMT

if you Need to check for null and blanks i would recommend to use this:

if(COLUMN_NAME='sales region' AND len(trim(COLUMN_NAME))>0, 'NON_BLANK_OR_NULL', 'BLANK_OR_NULL') as CHECK_COLUMN_NAME

Re: is null

raadwiptec — Mon, 18 Dec 2017 10:38:39 GMT

hi all,

iam basically checking multiple columns..

that is if column name is sales region and if the column name is sales office and the column value of sales office is blank or null then [sales reps france]

Re: is null

Anil_Babu_Samineni — Mon, 18 Dec 2017 11:56:34 GMT

Try to respond all

Anyway, from this case you can use like

If(Match([column name], 'sales region', 'sales office') and IsNull([column value]), 1,0) as [sales reps france]