Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Tell us which business and trade publications you read most regularly: RESPOND NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
krzysztof_toman
Contributor III
Contributor III

Qlik Sense - stacked bar chart - data model - dimensions - set analysis

Hi all,

I have a task I'm trying to solve. I've tested couple of ideas and I've got nothing but a partial solution (unsatisfactory).

Any help / pointing to a right direction much appreciated!

The goal:

One stacked bar graph displaying:

- one stacked bar: rolling forecasts (actuals, forecast values)

- second stacked bar: prior forecast (actuals, forecast values)

- stacked bar responding to filter pane (Date)

*note: to see how rolling and prior works in attached qvf use March-to-July as for other months there is no data available.

What I've done so far:

Cut original table to 3 tables (probably not the most optimal solution).

Created two stacked bar graphs instead of one.

Attachments:

Excel file with:

- Original data-set structure

- 3 sheets displaying 3 tables I've build (may not be the best way..)

- qvf with what I've got so far (two stacked bar graphs instead of one)


**I tend to omit the explanation on how the rolling and prior forecasts work (it is beyond the scope of this task - but if the explaining the logic is needed I can share the calculator with simple excel visualization).


Any questions let me know!

Thank you in advance!


Kind regards,

Chris.

4 Replies
sunny_talwar

In your attached qvf, I don't see anything in both your charts. You mentioned stacking charts when March to July is selected, but I don't see anything with or without selections. Have you attached the correct qvf file?

krzysztof_toman
Contributor III
Contributor III
Author

Hi Sunny,

yes the attached is the correct qvf.

I'm using desktop for this exercise (Qlik Sense Desktop September 2017 - but the qvf itself was developed in 3.2 SR4).

Adding a screen showing the graphs when March is picked from the Date list.

Capture1.PNG

Chris.

krzysztof_toman
Contributor III
Contributor III
Author

Adding the code for two bar graphs. Maybe this will help

marcingamza
Contributor
Contributor

Hi Chris,

You may use data island i the script to get a dimension on the chart, then you only need two measures to achieve the result.

See the attached files.

Hope it helps