Active BASE KPI

[master_student]

Hi everyone,

I need to know how to calculate the active base KPI. for example the number of activation from 2010 (when the database were created) until now.

Thank you,

[Oleg_Troyansky]

Hi,

this is a very open question and leaves a lot for us to guess... What is your particular problem?

Perhaps you could create a share a little example with your data and with the chart that you are having difficulties with.

cheers,

Oleg Troyansky

Check out my new book QlikView Your Business - The Expert Guide for QlikView and Qlik Sense

[master_student]

Hi Oleg,

I have a calendar table    activation table

%Date Id                       number of activation

calendar date                 Date of activation

month week

day

I convert the Date of activation into calendar date to link it with the calendar

I need to know  the number of activation for the whole periode.

Thanks in advance.

[Oleg_Troyansky]

If your dates are linked, then the result is simply

sum(NumberOfActivations)

am I missing something?

[master_student]

Hi Oleg,

Thanks for your reply.

My expected result is the sum (NbActivation) of all years whatever the selected year. When I do as you recommended, the measure will change with the year selected.

Thanks

[Oleg_Troyansky]

You can use Set Analysis to ignore User selections in the field Year. Learn about Set Analysis in the Help Section.

[maxgro · Accepted solution]

something like

sum({$ <Year=>} NumberOfActivations)

if you want the selection in “Year” field removed