topic Help with if expression in chart in QlikView

Help with if expression in chart

madsgrathe — Wed, 29 Dec 2010 13:11:51 GMT

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)

Wed, 29 Dec 2010 13:24:55 GMT

Hi MadsGrathe

Just try this

Avg(field_name)

hope its useful.

Regards,

Sri

syed_muzammil — Wed, 29 Dec 2010 13:25:19 GMT

Hi,

Try using Set Analysis,

sum({<LoginDays={'>5'}>} Sales)/count({<LoginDays={'>5'}>} distinct UserID).

madsgrathe — Wed, 29 Dec 2010 13:49:43 GMT

Thank you so much - worked like a charm 🙂

I had a feeling it had something to do with SetAnalysis...