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

Announcements
Qlik Connect 2026! Turn data into bold moves, April 13 -15: Learn More!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Need a variable

Hi i have a requirement which needs the exact formula. I have attached the table chart, which exactly shows the formula. I need the formula for Average visits per user per month  =

  (# of visits / Unique Users actually accessing QV) / (# of months) which is

=((Count(Distinct(if(Year([MONTH_END_DT])=Year([MinDateVar]),[Timestamp],0))))/(Count(distinct(if(Year([MONTH_END_DT])=Year([MinDateVar]),[User_Pin_Key],0)))))/???????

I want the formula for (# of months) which is the number of document accessed by a user in a month. It should be a variable. Since it may vary for different user accessing a document for different month.

0 Replies