Discussion Board for collaboration on QlikView Layout & Visualizations.
I HAVE A COUNT 3 CALCULATES FORMULAS THAT WORKS FINE.
I CALCULATE NEW SUPPLIER, LOSSER SUPPLIER, AND PORTFOLIO.
NOW I WONT TO NOW THE CHURN OVER THE YEAR.
BASICALY IS IT.
PORTFOLIO IN FIRST WEEK OF THE YEAR / ACCUMULATE LOSSER IN THE YEAR TO ACTUAL WEEK.
My problem is for the year before. how can i do it in the pass. right now I put the first week of the year in a variable.
and y count the portfolio in first week of year /
count with set anayliss week >= firstweekof year (variable) and <= actual week (variable) losser supplyer.
Thanks in advance
In a chart expression you can often use the above() function to retrieve the previous value of column. See the help file for detail. Or post a sample document with some data and an explanation of what the result should be.