topic Field with value NULL in QlikView

Field with value NULL

Thu, 04 Jun 2009 19:28:29 GMT

Hi all,

Somebody can help me?

Like the sample attached, how can I create a column ( name K) with value 5 if value k1 is Null and value Altro is not NULL, otherwise K set up with value of field K1?

Thank All

Field with value NULL

Thu, 04 Jun 2009 19:36:27 GMT

Hi,

Attach your data sources.

i could see only application.

- Sridhar

Field with value NULL

Thu, 04 Jun 2009 19:39:01 GMT

Hi,

Try droping your 1st table using below code.

drop table Sez1;

Note:

The above drop statement should be the last line of your script.

- Sridhar

Field with value NULL

sathishkumar_go — Thu, 04 Jun 2009 19:42:39 GMT

HI try this expression

(IsNull(K1) =-1 and IsNull(Altro)=0, 5) as K

its not working then attach ur excel file here

-Sathish

Field with value NULL

Thu, 04 Jun 2009 19:55:00 GMT

Sorry,

Now I attach the file QLV and the file Excel.

Thank All

Field with value NULL

Thu, 04 Jun 2009 20:05:46 GMT

Hi,

Check the attahed application now.

I would suggest you to go for len() function instead of isnull()

- Sridhar