Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

On May 18th at 10AM EDT we will answer your QlikView questions live. REGISTER
Showing results for 
Search instead for 
Did you mean: 
Contributor III
Contributor III

Set Analysis - Running Mean, Std, Skew and Kurtosis


I have a simple combo chart with a measure of daily rtns (as bars) and date as the dimension. I would like to add the running mean, std, skew and kurtosis (as lines) for the data points from the beginning to the ladder date.

If I filter on the date, then the mean, std,skew and kurtosis should be based on the daily returns within the filtered date. I would be grateful if you can provide the set analysis expression for doing this, using the terms

Dimension: Ladder_Date

Measure: Daily Rtns = SUM(TDY/NAV)

So for example:

If I use the expression Avg(Aggr(SUM(TDY/NAV), Ladder_Date)), this seems to aggregate across all the ladder_dates within the filter, but I want to show it as a the average from the beginning to the point in the ladder date, rather than the full set of ladder dates. So instead of a constant line, the line (the avg) should be different at each ladder_date point.

Any ideas?

1 Reply

I understand your requirement in bits and pieces. Would you be able to share a sample data with the expected output? That ways we will know exactly what you are looking for.