topic Using Dimension value in expression in QlikView

Using Dimension value in expression

Thu, 08 Oct 2009 14:10:45 GMT

Hi,

I'm wondering if it's possible to use the dimension value to do a calculation.

Dimension value would be a monthname e.g.

Dimension | Expression
Jan | sum(if(mymonth='Dimension value'
Feb....

Or can I handle this with set analysis?

Thanks for your help.

Elzo

Using Dimension value in expression

Thu, 08 Oct 2009 15:01:57 GMT

Hi Elzo,

have a look and let me know if it answers your question.

Good luck!

Rainer

Using Dimension value in expression

Thu, 08 Oct 2009 15:55:26 GMT

Hello Rainer,

thanks for your help. Maybe I understand your sample not correct but what I'm trying to achieve is the this:

I have a table chart with an date (monthname as dimension).
My expression should be independent from this dimension but do a calculation based on dimension date in another date field.
I know this sound weird 😉

I have several expressions based on the "month" dimension and one expresison that counts a field only if "the other date field" is equal to
the dimension datefield.

Thanks.

Using Dimension value in expression

Thu, 08 Oct 2009 15:58:17 GMT

Elzo,

do you have a small example for me to work with?

Rainer

Using Dimension value in expression

Thu, 08 Oct 2009 16:42:23 GMT

Hi Rainer,

please see attached application. Thanks for your help.

Using Dimension value in expression

Thu, 08 Oct 2009 18:39:16 GMT

Hi Elzo,

see the attached example.

Rainer

Using Dimension value in expression

Thu, 08 Oct 2009 19:02:20 GMT

Hi Rainer,

thanks a lot for your answer. Do you know if it would be possible without a calender?

Using Dimension value in expression

Thu, 08 Oct 2009 19:23:55 GMT

Elzo,

at the moment no.

If there is another way i´m sure that you will have to code some if statements and if your amount of data grow you have to pay for it by a slower performance.

Other points are different aggregation levels (daily sales vs. budget by month) and your script will end up as i suggested in this example.

Have a nice time using QlikView!!!

Rainer