topic Re: Bar in the chart should not show up unless we have data for all the four bars in QlikView

Bar in the chart should not show up unless we have data for all the four bars

nakuldev — Mon, 25 Jun 2018 06:20:26 GMT

Hi All,

In the attached qvw for 'Crane mechanic' only third quartile have values, as per my requirement if we have values for all the four quartiles then the bars should populate else no bar should get populated.

Thanks in advance

regards

Nakul

Re: Bar in the chart should not show up unless we have data for all the four bars

sunny_talwar — Mon, 25 Jun 2018 11:16:41 GMT

May be add this if statement in front of your expressions

If(Fractile(Unadjusted_Weekday_Standard_Hourly_Rate, 0.25) = Min(Unadjusted_Weekday_Standard_Hourly_Rate) or

Fractile(Unadjusted_Weekday_Standard_Hourly_Rate, 0.50) = Fractile(Unadjusted_Weekday_Standard_Hourly_Rate, 0.25) or

Fractile(Unadjusted_Weekday_Standard_Hourly_Rate, 0.75) = Fractile(Unadjusted_Weekday_Standard_Hourly_Rate, 0.5) or

Max(Unadjusted_Weekday_Standard_Hourly_Rate) = Fractile(Unadjusted_Weekday_Standard_Hourly_Rate, 0.75), Null(),

avg(Unadjusted_Weekday_Standard_Hourly_Rate))

Re: Bar in the chart should not show up unless we have data for all the four bars

nakuldev — Mon, 25 Jun 2018 14:03:03 GMT

Thank you Sunny!

The above expression is working fine but my bar-offset is starting from different values for some Labor type's. I changes the logic in bar-offset too but still it is same. Can we do something?

Thanks

Nakul

Re: Bar in the chart should not show up unless we have data for all the four bars

sunny_talwar — Mon, 25 Jun 2018 14:04:56 GMT

but my bar-offset is starting from different values for some Labor type's.

starting from different values? are you able to provide an example of this?

Re: Bar in the chart should not show up unless we have data for all the four bars

nakuldev — Mon, 25 Jun 2018 15:19:28 GMT

Hi Sunny,

PFA below image.

The Bar-offset should start at 'min()' but for few Labor type's it is starting from 'min()*2'. In the attached image, the fire/hole watcher's min() is 16 but the bar-offset had started from 32 i.e., (16*2).

Thanks

Nakul

Re: Bar in the chart should not show up unless we have data for all the four bars

sunny_talwar — Mon, 25 Jun 2018 15:28:35 GMT

I am not sure why, but I am seeing this

May be QlikView version issue like we discussed earlier?

Re: Bar in the chart should not show up unless we have data for all the four bars

nakuldev — Tue, 26 Jun 2018 07:26:50 GMT

Hi Sunny!

It's obviously QV version issue but still we are trying to achieve it in the version which we are using right now. Tried couple of ways but haven't achieved it 100%.

Anyways thank you very much Sunny for your quick response.

Thanks

Nakul

Re: Bar in the chart should not show up unless we have data for all the four bars

sunny_talwar — Tue, 26 Jun 2018 09:06:51 GMT

Nothing in your post made it sound so obvious . Anyways, this thread was about something else, do you mind closing this thread and opening a new thread which specifically points out the version you are using and looking for a solution in that version? This will help you get the right set of eyes to see your problem.