is null

[raadwiptec]

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]

[Anil_Babu_Samineni]

May be this?

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

[its_anandrjs]

Check some of this

NULL handling in QlikView

how to handle null values in qlikview

[its_anandrjs]

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

[zhadrakas]

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

[raadwiptec]

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]

[Anil_Babu_Samineni]

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]