topic Re: Ideas on creating Offset Bar chart in QlikView

Ideas on creating Offset Bar chart

nadkalyan — Mon, 20 May 2013 15:50:17 GMT

Hello,

Can anyone spell some ideas on creating the chart attached?

The dates are weekly dates and each bar represents a dimension based on status

Any ideas would be a huge help

Thanks

Kalyan

Re: Ideas on creating Offset Bar chart

Anonymous — Mon, 20 May 2013 15:58:28 GMT

Kalyan,

There is attribute expression bar offset, this is what you need.

Regards,

Michael

Re: Ideas on creating Offset Bar chart

nadkalyan — Mon, 20 May 2013 16:39:33 GMT

Michael,

The Bar Offset in the expression would help me acheive the waterfall kind of chart, however i need to have a dimension that basically gives first bar -total as of first day of the week, second bar - total of newly created in that week , and so on...and my ending bar would be what we ended up with as of last day of that week.

Hope this is clear

thanks

Kalyan

Re: Ideas on creating Offset Bar chart

Anonymous — Mon, 20 May 2013 16:58:20 GMT

For me it looks like a bar chart without dimensions, nine expressions.
1. Aggregation for the 1st day of the week. Use set analysis, e.g. sum({<Date={"$(=date(weekstart(Date)))"}>} Amount)
2. Aggregation for the newly cretae within the week, probably using set analysis of if(InWeek(Date))
...
9. Aggreagtion for the last day of the week, similar to the 1st one.
After that, apply offsets.
I hope it well help.

Regards,
Michael

Re: Ideas on creating Offset Bar chart

nadkalyan — Mon, 20 May 2013 20:27:32 GMT

Hi Michael,

That's a very good idea let me try to implement that and see how it works.

Thanks

Kalyan