topic Using dimension value in expression formula in QlikView

Using dimension value in expression formula

Fri, 07 Oct 2011 15:24:03 GMT

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...

Using dimension value in expression formula

jonathandienst — Fri, 07 Oct 2011 16:04:55 GMT

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

Using dimension value in expression formula

vincent_ardiet — Fri, 07 Oct 2011 16:11:19 GMT

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

Using dimension value in expression formula

Sat, 08 Oct 2011 18:48:11 GMT

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...

Using dimension value in expression formula

vincent_ardiet — Mon, 10 Oct 2011 14:05:45 GMT

Hi,

Try with :

- Dimension : PAPER_DATE

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

- Accumulation : Full Accumulation

It should work.

Regards,

Vincent

Using dimension value in expression formula

Wed, 12 Oct 2011 09:38:41 GMT

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

Best regards...

Cem