Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Customer & Partners, DEC. 9, 11 AM ET: Qlik Product & Strategy Roadmap Session: Data Analytics REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
arulsettu
Master III
Master 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
Creator III
Creator III

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.

View solution in original post

15 Replies
arulsettu
Master III
Master III
Author

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
Master III
Master III
Author

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
Master III
Master III
Author

any Idea?

quriouss
Creator III
Creator III

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.

View solution in original post

arulsettu
Master III
Master III
Author

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
Partner
Partner

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
Master III
Master III
Author

i will try

thanks

arulsettu
Master III
Master III
Author

how to avoid those zeros