topic Re: Help with chart in QlikView

Help with chart

hopkinsc — Thu, 05 Dec 2013 16:15:11 GMT

Hi all,

I am trying to create a straight /pivot table showing figures for this year (broken down by group) but also including a TOTAL column for last year then showing the variance between them both.

I have included a sample, cam anyone help with this? i am not sure if it can be achieved. I know i can do it in seperate chartts but i need it to go on a report and look good.

I was hoping for a result similar to the below.

Many thanks

Re: Help with chart

bbi_mba_76 — Thu, 05 Dec 2013 17:07:11 GMT

Hi,

I think you could

1. concatenate the 3 expressions using the dimensionality() function to set the total value (ie if(dimensionality()=0, Expr1&' '&Expr2...)

2. use calculated fields

Re: Help with chart

hopkinsc — Thu, 05 Dec 2013 17:38:01 GMT

Hi, thanks for your reply. is it possible you could show me what you mean using the sample please?

Re: Help with chart

Gysbert_Wassenaar — Thu, 05 Dec 2013 17:38:21 GMT

You can fake it with three pivot tables and some text boxes.

Re: Help with chart

hopkinsc — Thu, 05 Dec 2013 17:48:48 GMT

Hi Gysbert,

I have already tried that. it looks really good in the qvw itself but when i create a report and position the objects on the page it doesnt print everything correctly.

Re: Re: Help with chart

Gysbert_Wassenaar — Thu, 05 Dec 2013 18:20:49 GMT

Take 2.

Re: Help with chart

hopkinsc — Thu, 05 Dec 2013 20:45:04 GMT

actually i dont think that will work either as it needs to be at date level not year, and all the dates are in the inline table which i think will be a lot of maintenance also.

there would need to be a record for every day of the year by reportingreasongroup by reporting group for a maximum of 2 years.

this seems to be harder than i thought