Discussion Board for collaboration related to Creating Analytics for QlikView.
I need a help to resolve this problem
I have in Input in a pivot table
Applications Servers Months
A01 S1 Octobre-2012
A11 S1 Octobre-2012
A02 S2 November-2012
A03 S4 December-2012
A04 S2 January-2013
A14 S1 January-2013
A03 S1 February-2013
A01 S2 March-2013
I have to accumulate a number of distinct “applications” by month with a condition that is not accumulate “applications” if exist in previous month.
The expression I’m using is
Months Cumulated different Numbers Of Applications by month
February-2013 7 (a problem for me because A03 exist in December-2012)
March-2013 8 (a problem for me because A03 exist in October-2012)
And I want to have this result
February-2013 6 (because A03 exist in December-2012)
March-2013 6 (because A01 exist in Octobre-2012)
Thank you in advance for tour help.
I am working on this exact same issue. Anybody have an idea on this?
I am counting distinct values over time but in the accumulation it is not discounting the distinct values from the previous months in the selection.
I found a formula to count the values do not included in the previous month:
if (count(Period_MonthName)>1, MinString(Period_MonthName),Period_MonthName)
But I don't know how to transform this expresion to dimension! Do you have an idea?