Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Qlik Users, make your voice heard! Participate in Wisdom of Crowds® Market Study: Start Survey
cancel
Showing results for 
Search instead for 
Did you mean: 
berryandcherry6
Creator II
Creator II

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?

galax_allu
Specialist
Specialist

HI

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

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




berryandcherry6
Creator II
Creator II

Hi,

i need to get run rate of redirect click counts.

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