topic Re: Bar Chart in QlikView

Bar Chart

umartareen — Thu, 24 Jul 2014 06:20:29 GMT

Hi,

How do we display in a Bar Chart where the starting value of the next (following) bar should be from where the previous one ends, that is the maximum value of the previous bar should be the minimum starting point of the next bar. Here is a picture of what I'm trying to create. Please find the file attached.

Thanks in advance.

Re: Bar Chart

rohan_mulay — Thu, 24 Jul 2014 06:26:15 GMT

Hi Umar,

I attached an example with 1 table with the values and 3 graphics, the first at natural way, the secodn is with the bar offset and the last with the dual function... for bar offset go in expression tab and click on the '+' sign against the expression to expand the options and set the bar offset...

Re: Bar Chart

avinashelite — Thu, 24 Jul 2014 06:30:30 GMT

Hi Umar,

Use bar offset in the expression, if you go to expression u will see + mark please click on it and you will see the bar offset.

Re: Bar Chart

its_anandrjs — Thu, 24 Jul 2014 06:31:16 GMT

The chart is water fall chart

Suppose you have chart with expression

Sum(Metrics)

Ex:- Sum(Sales)

Then write this expression also in expression Bar offset

See the sanap:-

Re: Bar Chart

umartareen — Thu, 24 Jul 2014 06:47:53 GMT

Hi Rohan,

Thank you for the help. I did not receive the attachments.

Re: Bar Chart

umartareen — Thu, 24 Jul 2014 06:49:30 GMT

Thank you Anand Chouhan and Avinash.

Re: Bar Chart

umartareen — Thu, 24 Jul 2014 06:50:38 GMT

But it still doesn't work. I think the dual function should work.

Re: Bar Chart

Thu, 24 Jul 2014 06:52:03 GMT

Hi,

check this

How to create Water Fall Charts

Re: Bar Chart

Thu, 24 Jul 2014 07:07:34 GMT

Check Data visualization file in qlikview demo.

You can see the example for waterfall model.

This will help you in your logic.

Re: Bar Chart

rohan_mulay — Thu, 24 Jul 2014 07:08:39 GMT

please find attached

Re: Bar Chart

umartareen — Thu, 24 Jul 2014 07:26:49 GMT

Hey Sarathy,

It works perfect. Thank you.

Re: Bar Chart

umartareen — Thu, 24 Jul 2014 07:27:12 GMT

Thanks Guys

Re: Bar Chart

Thu, 24 Jul 2014 07:52:12 GMT

Hi,

If you find any answer correct ,please mark it as helpful or correct.

Thanks