Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi guys,
New to qlikview and to the forums so bear over with me [:)]
I'm trying to get a graph to show a calculated value for a selected group of cells.
I have 3 columns in my data: UserID, LoginDays and Sales.
I want to find the average sales per user, but only for users with a certain amount of LoginDays.
I've tried with a simple "if" statement, but I can't get it to work... Anyone?
Here's what I've been trying:
if(LoginDays>5,sum(Sales)/count(distinct UserID),0)
Hi,
Try using Set Analysis,
sum({<LoginDays={'>5'}>} Sales)/count({<LoginDays={'>5'}>} distinct UserID).
Hi MadsGrathe
Just try this
Avg(field_name)
hope its useful.
Regards,
Sri
Hi,
Try using Set Analysis,
sum({<LoginDays={'>5'}>} Sales)/count({<LoginDays={'>5'}>} distinct UserID).
Thank you so much - worked like a charm 🙂
I had a feeling it had something to do with SetAnalysis...