Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
berryandcherry6
Creator III
Creator III

calculating Monthly Run Rate

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?

3 Replies
maxgro
MVP
MVP

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

Its not about the answer, rather it’s about the question…

QlikCommunity Tip: How to get answers to your post?

Anonymous
Not applicable

HI

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

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




berryandcherry6
Creator III
Creator III
Author

Hi,

i need to get run rate of redirect click counts.

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