Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
BI & Data Trends 2021. Discover the top 10 trends emerging in today. Join us on Dec. 8th REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Master
Master

Replace to zero

hi all,

I have a pivot table  with the measure result is showing as null symbol

but I want to show as zeros in place of nulls

I tried different methods  but no luck

Dim:group

column:Date

Mesaure: groupvalue

tried

if(groupvalue='-' or isNull(groupvalue),0, groupvalue)

Thanks

sony

1 Solution

Accepted Solutions
Highlighted

Is it null or is it missing.... I think it would not be possible to replace missing value with 0 in the chart itself. In order to do this you would probably need to generate missing data in the script

Generating Missing Data In QlikView

View solution in original post

9 Replies
Highlighted
Master II
Master II

Hi,

try below methods,

Method 1:

if(Len(groupvalue)<=0 or IsNull(groupvalue) or groupvalue='-',0,groupvalue)

Method 2: // best approach

Alt(Sum(groupvalue), 0)

Method 3: // best approach

try to define null variable like below

NULLASVALUE *;

SET NullValue ='NULL' ;

or

SET NullValue ='-' ;


Still if you have issue, i would suggest you to provide the sample mock data and expected output. Thanks


Hope this helps to you


Regards,

Deva

Highlighted
Master III
Master III

try this

if(isnull(groupvalue),'0',groupvalue)

Highlighted
Master
Master

not working

Highlighted
Master
Master

not working

Highlighted
Master II
Master II

Hi,

share you mock app or sample data with expected output. that would be easy for us to check and help you

Highlighted
Master II
Master II

All Solutions by Deva should work. if "group value" is a field then [groupvalue] if it is a label than replace group value with the expression.


if(len(trim(groupvalue))>0,groupvalue,0)

Learning never stops.
Highlighted
Master
Master

it also not working

and the filed having  number values

Highlighted
Master II
Master II

all of the above solution should work unless we are missing something that is in the app. please post a sample . dummy data also will do .

Learning never stops.
Highlighted

Is it null or is it missing.... I think it would not be possible to replace missing value with 0 in the chart itself. In order to do this you would probably need to generate missing data in the script

Generating Missing Data In QlikView

View solution in original post