topic Re: Bar Chart with Pivot Functionality in QlikView

Bar Chart with Pivot Functionality

Wed, 08 Jul 2015 09:54:08 GMT

Hi All,

With reference to the attachment, we are required to created chart of sort with will have pivot functionality.

I was able to achieve the attached with stacked bar chart, now the additional requirement here is that if user clicks on any of the days(in this case Tuesday with * mark) the chart should expand and show alternate schedule.

Do you guys have any idea how this can be achieved.

Regards,

ASP

Re: Bar Chart with Pivot Functionality

avinashelite — Wed, 08 Jul 2015 11:09:30 GMT

This is not possible in Qlikview

Re: Bar Chart with Pivot Functionality

avinashelite — Wed, 08 Jul 2015 11:11:28 GMT

You can try with Gantt chart , its not exactly match your requirement but close to it

Recipe for a Gantt chart

hope this helps you

Re: Bar Chart with Pivot Functionality

vardhancse — Wed, 08 Jul 2015 11:14:27 GMT

In qlkview on click of any data in chart/table/any object will filter and show relevant data across data.

some work around, may be usefull

But in your scenario try to create

1. one text object on top of each day.

2. one more object(Chart) and give layout condition so that on click on Tuesday you can get the object.)

in order to achieve this we need create multiple objects with many variables and use layout conditions

Re: Bar Chart with Pivot Functionality

swuehl — Wed, 08 Jul 2015 11:46:31 GMT

I think your request is hard to implement with QV standard charts and objects, but you may consider using extensions.

Here is an example that shows something similar (not exactely the required), just to show what might be possible:

Gantt Chart Extension Object (version 2.0)