topic Re: doubt about set expresion in QlikView

doubt about set expresion

dcd123456 — Mon, 02 Jun 2014 12:12:46 GMT

Hello

i have a table with three columns Id, Date and Value, i need create a text objet that show the avg of the items that have a date in the current month. I try to use this expresions but don't work

ID	Date	Value
2000000001	05/04/2014	12
2000000003	08/06/2014	34
2000000004	05/04/2014	1
2000000006	15/05/2014	34
2000000007	01/06/2014	56
2000000008	05/05/2014	123
2000000009	08/05/2014	6
2000000010	05/04/2014	2

Text Object:

='AVG Current month: ' &avg({<Date={'month(today())'} >} Value)

='AVG Current month: ' &avg({<month(Date)={'month(today())'} >} Value)

the first expresion don't return any value and the second show error...

i have attached an excample, anybody could help me.

thanks

regards

diego

Re: doubt about set expresion

tresB — Mon, 02 Jun 2014 12:16:13 GMT

Create a month field in the script, like:

Load

Month(Date) as Month

Then, try like: ='AVG Current month: ' &avg({<Month={'$(=month(today()))'} >} Value)

Re: doubt about set expresion

Anonymous — Mon, 02 Jun 2014 12:18:32 GMT

Try this:

avg(if(InMonthToDate(Date,today(),0),Value))

Re: doubt about set expresion

mahesh_agrawal — Mon, 02 Jun 2014 12:53:19 GMT

Hi,

Use the following expression. It will work.

=avg({$<Date={'>=$(=makedate(2014,month(today()),01))'}>}Value)