Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
On May 18th at 10AM EDT we will answer your QlikView questions live. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
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
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

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

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
Author

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

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
Author

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

Best regards...

Cem