topic Re: "Superimposed" Histogram in QlikView

"Superimposed" Histogram

Wed, 12 Aug 2015 13:28:56 GMT

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

Re: "Superimposed" Histogram

Gysbert_Wassenaar — Wed, 12 Aug 2015 13:36:31 GMT

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

Re: "Superimposed" Histogram

Wed, 12 Aug 2015 13:51:18 GMT

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?!

Re: "Superimposed" Histogram

Wed, 12 Aug 2015 13:56:43 GMT

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

But If someonne have any ideas ...

Re: "Superimposed" Histogram

MarcoWedel — Wed, 12 Aug 2015 23:40:18 GMT

Hi,

maybe like this:

hope this helps

regards

Marco

Re: "Superimposed" Histogram

Thu, 13 Aug 2015 06:50:41 GMT

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

Re: "Superimposed" Histogram

MarcoWedel — Fri, 14 Aug 2015 22:29:18 GMT

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