topic Re: date functions inside set analysis in QlikView

date functions inside set analysis

Thu, 30 Oct 2014 16:48:18 GMT

Having trouble with dates and set analysis - the below does not resolve:

sum({< day={ date(my_date,'WWWW')}> } value)

Anyone know how to do date formatting inside set analysis?

alexandros17 — Thu, 30 Oct 2014 16:50:54 GMT

All function inside set analysis must be used with $ expansion:

sum({< day={'$(=date(my_date,'WWWW'))'}> } value)

let me know

Pay attaention to date formats

Thu, 30 Oct 2014 16:52:13 GMT

Try:

sum({<day = {'$(=date(my_date,"WWWW"))'}>}value)

Thu, 30 Oct 2014 17:00:30 GMT

thanks, this is what I was looking for