Using Dimension value in expression

[#1]

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

[#2]

Hi Elzo,

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

Good luck!

Rainer

[#3]

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.

[#4]

Elzo,

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

Rainer

[#5]

Hi Rainer,

please see attached application. Thanks for your help.

[#6]

Hi Elzo,

see the attached example.

Rainer

[#7]

Hi Rainer,

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

[#8]

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