Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

arulsettu
Honored Contributor III

how to avoid null values in table and chart

     hi,

i am trying to do cyclic group in qlik sense. but the result giving null values. same thing i used in qlikview it works prefectly.

can any one take a look. i attached the sample here

thanks

1 Solution

Accepted Solutions
quriouss
Contributor III

Re: how to avoid null values in table and chart

Are you saying you have nulls in your data (I can't download your .qvf due to network restrictions here)?

If so, you can get rid of them during the LOAD process;

NullAsValue *;

Set NullValue = '0';

This would replace all your nulls with zeroes.

15 Replies
arulsettu
Honored Contributor III

Re: how to avoid null values in table and chart

guys please take look on this

jagan

sunindia

MRKachhiaIMP

Re: how to avoid null values in table and chart

Which object are we looking at? The left object with the Pick statement? I have not used Qlik Sense well enough to know how cycle groups work in Qlik Sense, but I am more than happy to look with you, if you can help me learn how am I suppose to cycle?

arulsettu
Honored Contributor III

Re: how to avoid null values in table and chart

thanks for replying. left side object with pick is i am trying to do

i just followed this post for cyclic group

Makes Sense to go round in circles

According to the expression it should show top 10 values only but it showing with null values.

if any detail please ask

Thanks

arulsettu
Honored Contributor III

Re: how to avoid null values in table and chart

any Idea?

quriouss
Contributor III

Re: how to avoid null values in table and chart

Are you saying you have nulls in your data (I can't download your .qvf due to network restrictions here)?

If so, you can get rid of them during the LOAD process;

NullAsValue *;

Set NullValue = '0';

This would replace all your nulls with zeroes.

arulsettu
Honored Contributor III

Re: how to avoid null values in table and chart

i dont think null is in my data. but same thing works well in qlikview. i will attach app once again. please try to download

brijesh1991
Valued Contributor

Re: how to avoid null values in table and chart

Without this extension, you can do cyclic group and you can achieve null values suppression.

In script take a inline:

Dimension:

Load * inline
[

Dimension

Month

Year

Quarter

Product

];

Now take a table box:

In Dimention: write a calculated dimension:

if(Dimension='Month',Month,

if(Dimension='Quarter',Quarter,

if(Dimension='Year',Year,

if(Dimension='Product',Product))))

Now you can suppress null for above calculated dimension.


Write your expression in measure.


Now take a filter pane having Dimension as field


Hope it helps you!

Also attached options list extension will help you to select only one dimension at a time!!

arulsettu
Honored Contributor III

Re: how to avoid null values in table and chart

i will try

thanks

arulsettu
Honored Contributor III

Re: how to avoid null values in table and chart

how to avoid those zeros

Community Browser