topic Re: Re: Histogram subtype stacked in QlikView

Histogram subtype stacked

Thu, 03 Apr 2014 09:00:06 GMT

Dear,

We have created an histogram with data by year. We have chosen the subtype stacked to have all the data on one bar.

Now we want to add the data of year-1. We want to have the data next to each bar. We can calculate the data but it's not shown in a stacked bar. In total we need only two bar by month.

How can we do this?

Kind regards

Michael

Re: Histogram subtype stacked

cfz — Thu, 03 Apr 2014 13:00:16 GMT

Hi Michael,

There are some limitations regarding the choice of style (grouped/stacked) on a histogram depending of the number of dimensions and expressions. This is explained in the dekstop Reference Manual (page 645 version 11.20 SR5).

If you upload your QlikView document and a picture showing how you would like it to look like, I can try to help you.

Kind regards

Carlos

Re: Re: Histogram subtype stacked

Thu, 03 Apr 2014 14:13:55 GMT

Dear Carlos,

Here is a qlikview document and a picture showing what we want

Re: Re: Re: Histogram subtype stacked

cfz — Fri, 04 Apr 2014 12:37:19 GMT

Hi Michael,

To get the desired result my suggestion is:

Take away the set analysis part in each expression and add a calculated dimension instead to reflect the year restriction.

Choose Grouped instead of Stacked as Sub type in the Style tab in the Properties of the object.

I hope this helps

Kind regards

Carlos

Re: Re: Re: Histogram subtype stacked

Wed, 09 Apr 2014 07:27:09 GMT

Dear Carlos,

Thank you for your suggestion.

Il will propose your solution to my project manager

Kind regards

Michael

Re: Histogram subtype stacked

Mon, 02 Jun 2014 08:11:54 GMT

Dear Carlos,

Your suggestion was exactly what we are looking for.

I changed it to have cumulated values but when there is no data nothing is shown. (changing in your example to have cumulated results)

Do you have any idea how i can resolve that?

Kind regards

Michael