topic Re: Fractile calculation in Bar chart in QlikView

Fractile calculation in Bar chart

nakuldev — Thu, 14 Jun 2018 08:32:46 GMT

Hi All,

I am facing an issue with Fractile calculation in Bar chart. Wherever we have no data for any of the fractile then the bar-offset is going wrong. I have used min() in bar-offset but wherever we have no data for any of the fractile then the min() value is getting doubled and displayed in the chart. I tried with couple of logic's in order to avoid it. Could someone help me with this issue.

For example; In the attached sample.qvw you can check with Crane Mechanic Labor type.

PFA sample.qvw

Thanks & Regards

Nakul

Re: Fractile calculation in Bar chart

sunny_talwar — Thu, 14 Jun 2018 11:25:39 GMT

Why do you think that the minimum is getting doubled for Crane Mechanic? Look at this image

Minimum is 70 and that's where the chart is starting from...

Re: Fractile calculation in Bar chart

nakuldev — Thu, 14 Jun 2018 12:35:56 GMT

Hi Sunny!

For me its still showing up from 140. Have you done any changes? If yes could you please share your file.

Re: Fractile calculation in Bar chart

sunny_talwar — Thu, 14 Jun 2018 12:37:29 GMT

No changes

Re: Fractile calculation in Bar chart

nakuldev — Thu, 14 Jun 2018 12:44:56 GMT

Hey Sunny!

Have you applied any other filters other than Labor Type? I can still see the bar starting from 140. When I put the same expression in text object it is showing as 70 but bar is starting at 140.

Re: Fractile calculation in Bar chart

sunny_talwar — Thu, 14 Jun 2018 12:47:40 GMT

No other selection

QVW attached here Re: Fractile calculation in Bar chart

Re: Fractile calculation in Bar chart

nakuldev — Thu, 14 Jun 2018 12:54:08 GMT

Hi Sunny!

I have opened the version which you have sent sample(8) but its very strange. I still see the bar starting from 140. Is this something which I have to do it from my end?

Re: Fractile calculation in Bar chart

sunny_talwar — Thu, 14 Jun 2018 12:58:18 GMT

May be a version issue.... which version of QlikView are you using?

Re: Fractile calculation in Bar chart

nakuldev — Thu, 14 Jun 2018 13:11:45 GMT

QlikView November 2017 SR3

Version : 12.20.20400.0

Re: Fractile calculation in Bar chart

sunny_talwar — Thu, 14 Jun 2018 13:16:02 GMT

I am on Version 12.10 SR2.... Is it possible for you to downgrade?

Re: Fractile calculation in Bar chart

nakuldev — Fri, 15 Jun 2018 08:08:04 GMT

I need to check on this.

Thank you Sunny! At-least I came to know it's a version issue.

Thanks

Nakul