Discussion Board for collaboration related to Creating Analytics for QlikView.
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;
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?
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.
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.
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...
Try with :
- Dimension : PAPER_DATE
- Expression : sum(if(PAYING_DATE>PAPER_DATE,EXPIRED_DEBT))
- Accumulation : Full Accumulation
It should work.
Thank you for your responses. I have changed the design of the report.