Discussion Board for collaboration on QlikView Scripting.
how to implement null values in qlikview?
See here as starting point:
NULL – The Invisible Nothing
The Importance of Nothing
Rather than the stated methods,is their any other method?
What do you mean with "stated methods"? What do you want to do?
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.
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)
Back end (Script level)
if(ISNULL(Discount),1, Discount) as Discount
(ooxml, embedded labels, table is Sheet2);
Sales * Discount
Sales * Alt(Discount,2)
Hope this will help you...
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