topic Graphical help in QlikView

Graphical help

samvile18 — Thu, 31 Mar 2011 10:15:23 GMT

Hello,

I know this is possible as I've seen it before but can't remember how to do it!!

How do you see a year by year comparison on a bar chart...I've seen it before where the previous year shadows behind the current data.

Graphical help

deepakk — Thu, 31 Mar 2011 10:30:04 GMT

Hi,

Since you want a year comparison with bar chart the you can simply add the year as dimesion.

you can create two expression one for current year like below

Sum({<Year={$(=Max(Year))}>} Sales )

and for previous year

Sum({<Year={$(=Max(Year)-1)}>} Sales )

I hope this helps.

Graphical help

samvile18 — Thu, 31 Mar 2011 10:32:36 GMT

I've actually got the dimensions working properly...I'm just trying to add the ghosting function, I swear it's just a button you can click!

Graphical help

Thu, 31 Mar 2011 10:46:48 GMT

Hi Sam,

Is the "ghosting function" you are looking for a set reference, i.e. on the front-end object, right-click, choose set reference and then make another selection. You will have the bars with selction showing in full colour and the set reference bars in the background with a slightly transparent colour.

Set reference only works when a cyclical dimension is not involved in the chart. Don't know if they have changed that in v10.

Graphical help

samvile18 — Thu, 31 Mar 2011 10:53:03 GMT

Thats exactly what I'm after...the dimension is cyclical too...DAMN IT!

Thanks for the reply

Graphical help

Thu, 31 Mar 2011 10:57:28 GMT

Have had clients that needed the set reference. Only workaround is creating N-times the chart object to allow for set ref on all chart-dimension combos. Don't know of a way around that one.

If on v10, and depending on if the amount of dims included in the cycle, would be good to use a container object. It should work like that. Sorry can't help more.