topic Re: Active BASE KPI in QlikView

Active BASE KPI

master_student — Wed, 25 Nov 2020 16:16:04 GMT

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,

Re: Active BASE KPI

Oleg_Troyansky — Fri, 10 Jun 2016 14:45:09 GMT

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

Re: Active BASE KPI

master_student — Mon, 13 Jun 2016 08:18:53 GMT

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.

Re: Active BASE KPI

Oleg_Troyansky — Fri, 17 Jun 2016 00:14:45 GMT

If your dates are linked, then the result is simply

sum(NumberOfActivations)

am I missing something?

Re: Active BASE KPI

master_student — Fri, 17 Jun 2016 07:36:15 GMT

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

Re: Active BASE KPI

Oleg_Troyansky — Sun, 19 Jun 2016 16:57:46 GMT

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

Re: Active BASE KPI

maxgro — Sun, 19 Jun 2016 18:10:59 GMT

something like

sum({$ <Year=>} NumberOfActivations)

if you want the selection in “Year” field removed