topic Re: Set Analysis in QlikView

Set Analysis

Thu, 03 Dec 2015 19:43:20 GMT

Hi,

how to show Last month sales i am getting syntax problum please help me

sunny_talwar — Thu, 03 Dec 2015 19:48:21 GMT

Your Month Year field is text field and not Dual (Date) Field. Make these changes in the script and rerun:

LOAD MonthName(Date#([Month&Year], 'MMM YYYY')) as MonthYear,

Sales

FROM

[USA.xlsx]

(ooxml, embedded labels, table is Sheet1);

Once you have done that, try this expression:

=Sum({<MonthYear= {"$(=MonthName(AddMonths(Max(MonthYear), -1)))"}>} Sales)

MK_QSL — Thu, 03 Dec 2015 19:48:48 GMT

Current Month

=num(sum({<[Month Year]= {"$(=Date(Max(Date#([Month Year], 'MMM YYYY')),'MMM YYYY'))"} >}Sales))

Last Month

=num(sum({<[Month Year]= {"$(=Date(Max(AddMonths(Date#([Month Year], 'MMM YYYY'),-1)),'MMM YYYY'))"} >}Sales))

maxgro — Thu, 03 Dec 2015 19:58:07 GMT

Count({$ <[Month Year]={"$(=(Date(Max(AddMonths(Date#([Month Year], 'MMM YYYY'),-1)), 'MMM YYYY')))"}>} [Month Year])