topic Re: How to display two values behind themself in QlikView

How to display two values behind themself

Thu, 02 Aug 2012 10:38:47 GMT

Hi, I would like to ask you for help.

I have two expression values - "Objectives" and "Sales" and "Month"as a dimension. I would like to have "Objectives" behind "Sales".

To choose "stacked" option is wrong because the values are then numbered. 3D view is possible only with dimensions as I know and tried.

Here is example:

Thank you so much for help!

Mirek

Re: How to display two values behind themself

Thu, 02 Aug 2012 10:50:46 GMT

Choose Bar Chart in "General". Add your 2 Dimensions. Under "Style" choose the one that looks like you want (it's the left column right at the bottom on QV 10 under the "Look")

That should get you what you want

Re: How to display two values behind themself

Thu, 02 Aug 2012 11:05:09 GMT

Hi, thank you for answer, but I dont understand which dimension should I add. 3D is possible only with more dimensions than one. Should I put second expression to dimensions?

I just created QVW for show, thank you!

Re: How to display two values behind themself

Anonymous — Thu, 02 Aug 2012 11:06:51 GMT

if these are two different expressions...

i would suggest you can try to fake it..

by overlaying another chart with transaparent background..

have one expression in each chart with the same dimension...

adjust the position of the two charts in such a way that you get your desired effect..

Re: How to display two values behind themself

Anonymous — Thu, 02 Aug 2012 11:15:16 GMT

check attached doc..

Re: How to display two values behind themself

Thu, 02 Aug 2012 11:19:40 GMT

Thank you for fine advice 🙂 I just tried it and it somehow work. But I know that proper way does exist to do it, may be somebody will know 🙂

Thank you anyway!

Re: How to display two values behind themself

Thu, 02 Aug 2012 11:22:50 GMT

Slightly changed the dataset

Re: How to display two values behind themself

Thu, 02 Aug 2012 12:40:41 GMT

Thank yoooou so much!