Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Not applicable

Using dimension value in expression formula

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

dim_exp.jpg

5 Replies
MVP
MVP

Using dimension value in expression formula

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

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
vincent_ardiet
Contributor III

Using dimension value in expression formula

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

Not applicable

Using dimension value in expression formula

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
Contributor III

Using dimension value in expression formula

Hi,

Try with :

- Dimension : PAPER_DATE

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

- Accumulation : Full Accumulation

It should work.

Regards,

Vincent

Not applicable

Using dimension value in expression formula

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

Best regards...

Cem

Community Browser