topic Re: Help with Expression in QlikView

Help with Expression

Wed, 30 Jan 2013 20:34:03 GMT

My data that I have attached provides an

agent name,

unique sale #,

hire date of the agent

and the date of the sale.

I need to provide an analysis that will allow me to show a count of sales per week. However I need to exclude data where the agent was hired within the last 60 days in relation to the date dimension.

Any guidance would be appreciated. I have attached my data table in an excel spreadsheet.

Thanks!

Re: Help with Expression

dmohanty — Wed, 30 Jan 2013 20:56:49 GMT

you can use something like in Set Analysis:

Count( { $<HireDate<60>} Sale#)

Re: Help with Expression

Wed, 30 Jan 2013 23:00:01 GMT

Create a variable vagentdate as "=date(Today() - 60)" so that you can configure the number any time and have the expression as count({<[Agent Hire Date] = {'>$(vagentdate)'}>}[Unique Sale ID]) . This will give the sales count of a agent whose hire data is 60 days before today.