set analysis MonthName problem

Thu, 07 Feb 2013 09:25:59 GMT

Hi,

I have a set analysis problem, I want to see the sum of sales of the max month and year and later max monthyear -1. I used these set analysis expressions:

max(MonthYear) gives 41306 so i used MonthName(max(MonthYear)) which gives me the text: feb 2013

But when I use it to calculatie the sum of the sales I don't get a result:

num(sum({$<MonthYear={$(=MonthName(max(MonthYear)))}>}Sales),'#.##0,00')

There is no problem in my data because num(sum({$<MonthYear={'feb 2013'}>}Sales),'#.##0,00') gives me a result.

Does anyone know what's wrong with my syntax?

Re: set analysis MonthName problem

sbaldwin — Thu, 07 Feb 2013 09:56:57 GMT

Hi, try adding quotes round your $ expansion ie:

num(sum({$<MonthYear={'$(=MonthName(max(MonthYear)))'}>}Sales),'#.##0,00')

Thanks

Steve

Re: set analysis MonthName problem

Thu, 07 Feb 2013 09:59:34 GMT

Yes! Thanks for your help.

topic Re: set analysis MonthName problem in QlikView

set analysis MonthName problem

Re: set analysis MonthName problem

Re: set analysis MonthName problem