topic Use dimension value in expression in QlikView

Use dimension value in expression

guyvermeiren — Tue, 07 Dec 2010 16:00:21 GMT

Hello,

I would like to create a table where in the dimesion I have year and month and in expressions the turnover for actual year and turnover for year-1.( See example ). I think I have to use the dimension value in my expression. I this correct ? If not, how can this be done succesfully ??

Thanks

Kind regards,

Guy

Use dimension value in expression

Tue, 07 Dec 2010 16:23:04 GMT

Hi,

Did you tried set analysis?

in your expression, you can inspire from this : =SUM( { $<YEAR={$(=Only(YEAR)-1) } >}turnover)

This should give you the results for the selected year and the previous one.

Hope this helps.

Will

Use dimension value in expression

guyvermeiren — Tue, 07 Dec 2010 16:42:50 GMT

Hello Will,

This doesn't work. It gives only zero's in th column 'Year-1'.

Any other suggestions ??

Thanks,

Guy

Use dimension value in expression

Tue, 07 Dec 2010 18:32:12 GMT

Hi,
Why not go for something like this?

using something like:
sum({$<Year = {$(=max(Year))}>} Counter)

sum({$<Year = {$(=max(Year)-1)}>} Counter)

Use dimension value in expression

Wed, 08 Dec 2010 09:05:25 GMT

Hey,

It's true that JonB 's idea should work better.

Use dimension value in expression

guyvermeiren — Wed, 08 Dec 2010 09:27:11 GMT

Hello JonB,

The idea is OK but isn't this a standard pivottable. What I want to have is in my column the consecutive months as in in my example I added. EXample: from october 2009 untill september 2010 ( result of selection month/year in listbox).

Thanks anyway.

Kind regards,

Guy

Use dimension value in expression

Wed, 08 Dec 2010 11:55:06 GMT

Hi Guy,

I made something that should interest you

Hope this helps,

Will