topic Show all preceding months in QlikView

Show all preceding months

Mon, 23 Jan 2012 01:56:22 GMT

Hi,

I need to shoe all preceding months from the start of the year and current month sales when a month is selected. Eg, If Apr-2011 is selected, we should dsiplay Jan-2011,Feb-2011,Mar-2011 and Apr-2011. Any help is appreciated. Thanks.

Show all preceding months

CELAMBARASAN — Mon, 23 Jan 2012 05:03:23 GMT

Sum({<Year={$(=Max(Year))},Date={"<=$(=vCurrentDate)"}>} Sales)

Hope this helps

Celambarasan

Show all preceding months

jagan — Mon, 23 Jan 2012 05:37:44 GMT

Hi,

Try this

Sum({<Year={$(=Max(Year))}, Month=, Date={"<=$(=Max(DateField))"}>} Sales)

Hope this helps you.

Regards,

Jagan.

Re: Show all preceding months

Mon, 23 Jan 2012 05:58:46 GMT

Hi!

Try This,

PFA for Help.

Expression: Sum({<MonthYear,Date=, Year=,MonthNo.={$(vtest)}>}Sales)

vtest=concat({1<MonthNo.={">=1<=$(=max(MonthNo.))"}>} distinct MonthNo.,',')

Dimension:MonthYear