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

[vanand3535]

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()?

[jonathandienst]

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]

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]

replace null to 'No Data'

[jonathandienst]

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

[vanand3535]

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]

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]

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]

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.