topic Re: Two selections in QlikView

Two selections

Tue, 21 Aug 2012 17:49:19 GMT

Hi Community

Support me please. Any help is important

I have two selections

29/01/2012

12/02/2012

Of which I need to bring the maximum month year -1, (I need information from the previous month Jan 2012) I have the following statement

sum ({$ <[Month Year] = {'$ (= MonthName (AddMonths (max (Date), -1)))'}, {ClaseCoste = '520065 '}>} CantidadORD)

= sum ({$ <ClaseCoste = {'520065 '},

[Month Year] = {'$ (= MonthName (AddMonths (max ([Month Year]), -1)))'},

year =

CantidadORD)

I can suggest some judgment.

Thanks for your support and greetings

MayilVahanan — Tue, 21 Aug 2012 18:15:10 GMT

Try like this

=Sum( {< Monthyear = {'$(= MonthName (AddMonths (max (Date), -1)))'}, ClaseCoste = {520065}>}Sales)

and make sure that . Both = MonthName (AddMonths (max (Date), -1)) and Monthyear are same format

Hope it helps

Tue, 21 Aug 2012 19:05:46 GMT

Thanks for the support

Sum( {< [Mes Año] = {'$(= MonthName (AddMonths (max (Fecha), -1)))'}, ClaseCoste = {520065}>}CantidadORD)

Thus was my judgment and achievement data.

my date format is:

Date 29/01/2012

month Jan 2012

year 2012

regards

MayilVahanan — Tue, 21 Aug 2012 19:52:25 GMT

fecha is date, am i correct? And did you get the expected result?