Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
vanand3535
Creator III
Creator III

How to include zero or null values in Fractile() in Qlik Sense

Hi all,

I'm using a fractile() where I'm getting a different result that is not equal to expected one.

My expression is like this:-

fractile({<year={'2012','2013','2014','2015'}>}Sales,.25)


there are some null or blank or zero values in year filed like sales(2013)=0 or sales(2014)=0 and so on...

that's why I'm getting the exact result.

I think this expression is not including the zero or something

So How can I include the zero values in Fractile()?


9 Replies
jonathandienst
Partner - Champion III
Partner - Champion III

I think zeroes are included in the calculation but nulls are not. Perhaps

Fractile({<year={'2012','2013','2014','2015'}>} Alt(Sales, 0), 0.25)

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
vanand3535
Creator III
Creator III
Author

I tried this but there is no change in output value same as earlier.

No increment or decrement in output value and same as earlier.

sunny_talwar

Would you be able to share few rows of data with the output you expect to see from it?

zebhashmi
Specialist
Specialist

replace null to 'No Data'

jonathandienst
Partner - Champion III
Partner - Champion III

I think a text value will also be ignored in the statistics functions like Avg and Fractile.

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
vanand3535
Creator III
Creator III
Author

Hi Jonathan,

I have checked my database and I found that we have only numerical values like 11,33,45,0 and so on..

Two years have  value where sales = 0 like 2012,2015

vanand3535
Creator III
Creator III
Author

Hi Hashmi,

I have checked my database and I found that we have only numerical values like 11,33,45,0 and so on..

Two years have  value where sales = 0 like 2012,2015

vanand3535
Creator III
Creator III
Author

Hi Sunny,

I have checked my database and I found that we have only numerical values like 11,33,45,0 and so on..

Two years have  value where sales = 0 like 2012,2015

vanand3535
Creator III
Creator III
Author

Hi all,

This is the data where I'm using filter on season and games_missed

My expression is like this:-

fractile({<SEASON={'2012','2013','2014','2015','2016'}>}GAMES_MISSED,.25)

I'm not getting exact value.