"Superimposed" Histogram

[#1]

Hello,

I have problem with a histogram.
I have a histogram that display value for 2015 et 2014 by selected month. So far so good.

Next,I want 2014 fill gradually over the month based on the month of December.
I have a begining solution (see attachment), but I'm not satisfied.

In my graphic Histogram 1 for 2014 he add the current month and December.
In the histogram 2, it's better, but the value of December 2014 is not good.

I think i'm not clear, and hope that the document attached will help to understand my problem.

Any ideas ?

Thanks to your help

[Gysbert_Wassenaar]

I'm afraid I don't understand why you think the value of December 2014 is not correct in Histogram 2.

[#3]

Hi, When you put your mouse to display value on the histogram, you can see the value to Dec.12 is 91, but the real value is 145 (value display in historgam 1).

In histogram 1 ,  my expression is sum( {<Month1 = {'12'} > } Value )  , but to 2014 he add  the value of the selected month.

In histogram 2, my expression is sum( {<Month1 = {'12'} > } Value ) - sum( {<Year1 = {2014} >} Value) . I want that the height of my barre to 2014 don't move with the selected month (it's ok in the second histogram), the value display to dec-2014 is not the good value.
It's little dangerous and bad for users !! I hope it's more clear?!

[#4]

I can desactivate the label tooltip... but i would like can display the value.

But If someonne have any ideas ...

[MarcoWedel · Accepted solution]

Hi,

maybe like this:

hope this helps

regards

Marco

[#6]

Hi Marco,

Thanks to your answer, it seems solve my problem. But I don't really understand the DUAL function and I didn't find (or i don't understand) explication on QlikView-Manuel or Web...

Someone to explain to me this function ?

Simon

[MarcoWedel]

Hi,

you're welcome.

Dual() simply formats a number with a different text representation.

So in this case, it still uses the numerical value 91 to calculate the bar chart, but displays this number using the text "145".

hope this helps

regards

Marco