FORMULA IN LAYOUT

Fri, 27 Jun 2014 06:30:11 GMT

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

Re: FORMULA IN LAYOUT

Gysbert_Wassenaar — Fri, 27 Jun 2014 07:16:08 GMT

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.

topic FORMULA IN LAYOUT in QlikView

FORMULA IN LAYOUT

Re: FORMULA IN LAYOUT