Using dimension value in expression formula

[#1]

Hello everyone,

I need to use my dimension value in the expression formula.

The table has always last 12 months as dimension and sum of debts as expression. I want to calculate sum of debts for the every dimension value (month).

I need to write a formula like;

=Sum(if(DATE_ON_PAPER<='monthname',VALUE))

for every month, in order to get the monthly picture of the total debts and how the trend is going...

Could you please help me?

Thank you...

[jonathandienst]

Hi

Maybe I've missed the point, but to do this in QV, create a chart with the month as the dimension and Sum(DATE_ON_PAPER) as the expression.

Regards

Jonathan

[vincent_ardiet]

Hi,

Are you trying to obtain a running sum ?

Do you want that the total for february is the one for january + the one for february ?

If this is the case, you can choose "Full accumulation" in the expression panel in the "Accumulation" box.

Regards,

Vincent

[#4]

Hi,

Thanks for your responses...

This data comes from SAP. The debts and credits are matched and balance for customers are calculated.

For example i need to calculate the expired debt of a customer at the end of January.(January is my dimension value). in sql i would write

select SUM(EXPIRED_DEBT) where PAYING_DATE>January and  PAPER_DATE<=January

When i write this formula in qlikview and choose the corresponding dimension value(January) it works. But i need to calculate theese values for every each dimension. and show it like a table.

So instead of 'January' i must write the dimension...But i can't...

Regards

Cem...

[vincent_ardiet]

Hi,

Try with :

- Dimension : PAPER_DATE

- Expression : sum(if(PAYING_DATE>PAPER_DATE,EXPIRED_DEBT))

- Accumulation : Full Accumulation

It should work.

Regards,

Vincent

[#6]

Thank you for your responses. I have changed the design of the report.

Best regards...

Cem