calculating Monthly Run Rate - Qlik Community

berryandcherry6 · ‎2016-08-08

Hi all,

I have a table called useractivitylog table, where we store log_type_id= 2 as redirect

table contians below column:

user_activity_log_id, user_id, client_id, client_name, activity_start_time, activity_end_time, user_agent, status, log_type_id

Now i want to calculate Monthly run rate for this 'log_type_id= 2' counts.

What i have tried.

count({$<log_type_id={'2'}>}user_activity_log_id)

in above equation i am getting count of user_activity_log_id where log_type_id={'2'}.

Now i need to calculate run rate monthly for log_type_id counts.

How could i do this?

maxgro · ‎2016-08-08

I think you don't get any answers because is difficult to understand your question

Try to read the 2 link or post a qvw, an excel with some source data and the expected output

Anonymous · ‎2016-08-08

HI

Are you looking for count of 'redirect' for the current month ?

count({<{">=$(=Num(MonthStart(Max(Datefield))))<=$(=Max(Datefield)"}>} redirect)

berryandcherry6 · ‎2016-08-08

Hi,

i need to get run rate of redirect click counts.

Formula to calculate run rate of redirect click counts will be usefull