Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

FORMULA IN LAYOUT

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

1 Reply

Re: FORMULA IN LAYOUT

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.


talk is cheap, supply exceeds demand
Community Browser