topic Re: Bar offset when value from previous expression is null in QlikView

Bar offset when value from previous expression is null

apoorvasd — Tue, 12 Sep 2017 14:55:46 GMT

Hi All,

I am trying to create a bar chart in which the bar height of second expression should start from the ending of bar from expression one and so on. In bar offset of second expression I have provided first expression and it works fine and I see that the bars are placed properly. But the problem is, when the expression value of first expression is null, then I do not see second expression bar. I only see the value of it. How can I write an expression in bar offset option to see the second bar even when the first expression value turns out to be null (or doesn't have any entry in that field)?

Any suggestions?

Thank you.

Re: Bar offset when value from previous expression is null

sunny_talwar — Tue, 12 Sep 2017 15:08:23 GMT

Would you be able to share a sample?

Re: Bar offset when value from previous expression is null

apoorvasd — Tue, 12 Sep 2017 16:12:42 GMT

PFA.

Thank you.

Re: Bar offset when value from previous expression is null

sunny_talwar — Tue, 12 Sep 2017 16:49:27 GMT

Check now

Re: Bar offset when value from previous expression is null

apoorvasd — Wed, 13 Sep 2017 04:39:00 GMT

Hi Sunny,

Yes, that is what I wanted. But there is a small difference that I see here. In the attached image, third bar has to start from where the second bar ends. But I see that it starts from x-axis line. Is it possible to manipulate the expression and make the third bar start from the point where second bar ends?

Or is it possible to create the bars in below format?

Thank you.

Re: Bar offset when value from previous expression is null

sunny_talwar — Wed, 13 Sep 2017 08:27:34 GMT

Here you are.... changed the bar offsets for the 3rd and the 6th expression by adding the bar offset of 2nd and 5th expressions to 3rd and 6th, respectively.

Re: Bar offset when value from previous expression is null

apoorvasd — Wed, 13 Sep 2017 08:32:12 GMT

Perfect! Thank you very much