topic Re: graph with mixed dimensions in QlikView

graph with mixed dimensions

osni_campos — Wed, 19 Mar 2014 19:25:12 GMT

Good Afternoon!

I need to create a chart, which has only one dimension, however should be mixed, which must have:

-Accumulated conducted the previous year as well as expected;

-Current year Accumulated performed as well as expected;

The well-performed as Predicted from month to month of the current year.

Can someone give me a light?

thank you,

Re: graph with mixed dimensions

Wed, 19 Mar 2014 20:31:26 GMT

Can you attach a sample file with some data and elaborate a little more on the expressions you need.

Re: graph with mixed dimensions

MarcoWedel — Wed, 19 Mar 2014 21:47:36 GMT

Hi Osni,

I'm also not quite clear what you need exactly, but as you mentioned that you want multiple calculations combined in only one dimension, maybe this is, what you are looking for:

I used this synthetic dimension:

=valuelist('PreviousYearPerformed', 'PreviousYearExpected', 'CurrentYearPerformed', 'CurrentYearExpected')

and this expression:

=pick(match(valuelist('PreviousYearPerformed', 'PreviousYearExpected', 'CurrentYearPerformed', 'CurrentYearExpected'),'PreviousYearPerformed', 'PreviousYearExpected', 'CurrentYearPerformed', 'CurrentYearExpected'),
sum({$<Year={$(=max(Year)-1)}>}performed),
sum({$<Year={$(=max(Year)-1)}>}expected),
sum({$<Year={$(=max(Year))}>}performed),
sum({$<Year={$(=max(Year))}>}expected)
)

Hope this helps

regards

Marco

Re: graph with mixed dimensions

osni_campos — Thu, 20 Mar 2014 10:58:05 GMT

Good Morning

The model described / attached by Marco Wedel, This is just a data structure that I have.

However the graph beyond the columns placed, must include the month for the current year.