Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Highlighted
Partner
Partner

ACTUAL MONTH IN SET ANALISYS

Hi expert, i have an object that i simply show the sales for the actual month year

i am using set analisys

Sum({<[Mes Año]= date(max([Mes Año]), 'MMM-YYYY')>}, sales)

where is the error?

thank you a lot

Fernando

1 Solution

Accepted Solutions
Partner
Partner

Re: ACTUAL MONTH IN SET ANALISYS

Sum({<[Mes Año]= {"$(=date(max([Mes Año]), 'MMM-YYYY'))"}>} sales)

1 Reply
Partner
Partner

Re: ACTUAL MONTH IN SET ANALISYS

Sum({<[Mes Año]= {"$(=date(max([Mes Año]), 'MMM-YYYY'))"}>} sales)