topic how to implement null values in qlikview? in QlikView

how to implement null values in qlikview?

sumitjadhav — Mon, 28 Dec 2015 08:44:30 GMT

how to implement null values in qlikview?

Re: how to implement null values in qlikview?

marcus_sommer — Mon, 28 Dec 2015 09:09:44 GMT

See here as starting point:

NULL – The Invisible Nothing

The Importance of Nothing

Finding NULL

- Marcus

Re: how to implement null values in qlikview?

sumitjadhav — Mon, 28 Dec 2015 11:17:16 GMT

Rather than the stated methods,is their any other method?

Re: how to implement null values in qlikview?

marcus_sommer — Mon, 28 Dec 2015 14:10:52 GMT

What do you mean with "stated methods"? What do you want to do?

- Marcus

Re: how to implement null values in qlikview?

vikasmahajan — Tue, 29 Dec 2015 04:57:08 GMT

if( PROD_GROUP_ID = 0,1,if(ISNULL(PROD_GROUP_NAME) OR LEN(PROD_GROUP_NAME)=0,1,0)) AS IsMissingProductGrp,

This way you can check null values in script level and avoid in charts or finding where null goes wrong.

HTH

Vikas

Re: how to implement null values in qlikview?

rajeshforqlikvi — Sat, 09 Jan 2016 02:15:48 GMT

I hope you want to handle null values what i understood from your question.

There are there ways to handle it.

1. Go to properties -> Dimension -> suppress when value is null.

2. Use ALT function on the UI level to handle the Null values.(for more details refer QlikView Help manu)

3. Use isnull() function in the script side to handle the Null values.(for more details refer QlikView Help manu)

Regards

Rajesh Kumar

Re: how to implement null values in qlikview?

rajeshforqlikvi — Sat, 09 Jan 2016 02:22:39 GMT

Back end (Script level)

LOAD Year,

Sales,

if(ISNULL(Discount),1, Discount) as Discount

FROM

C:\Qlikview\AAA.xlsx

(ooxml, embedded labels, table is Sheet2);

Expression level:

Sales * Discount

Sales * Alt(Discount,2)

Hope this will help you...

Regards

Rajesh Kumar

Re: how to implement null values in qlikview?

Kushal_Chawda — Sat, 09 Jan 2016 06:43:36 GMT

Example in script

=if( ISNULL(Category),'NULL',Category) as Category

=if( len(trim(Category))<=0,'NULL',Category) as Category

In front end You can create the calculated dimension like below

=aggr(if( ISNULL(Category),'NULL',Category),Category)

aggr(if( len(trim(Category))<=0,'NULL',Category),Category)