how to avoid null values in table and chart

[arulsettu]

     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

[arulsettu]

guys please take look on this

jagan

sunindia

MRKachhiaIMP

[sunny_talwar]

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]

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]

any Idea?

[quriouss · Accepted solution]

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]

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]

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]

i will try

thanks

[arulsettu]

how to avoid those zeros