Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

vanand3535
Contributor

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

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

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

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

vanand3535
Contributor

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

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.

MVP
MVP

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

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

zebhashmi
Valued Contributor

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

replace null to 'No Data'

MVP
MVP

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

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

vanand3535
Contributor

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

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
Contributor

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

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
Contributor

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

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
Contributor

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

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.

Community Browser