select possible month qlikview

[techvarun]

Hi,

I want to select Possible Months less than the current month Selected

I have a month filter on home page

if i select july i need to show trends from Jan to July

I have the trend ready but need ur help on setting the trend months

Thanks

Varun

[amit_saini]

Check this:

Calculating prior month based on selection

Thanks,
AS

[sushil353]

Hi,

you can use set analysis to achieve the same.

sum({<month={"< $(=Max(month))"}>}field)

HTH

Sushil

[techvarun]

my monthfield is monthselected and i have to use the months on a line graph

[#5]

sum({<monthselected={"< $(=Max(monthselected))"}>}field)

[techvarun]

Hi I want to select in field

On OnactivatePage Trigger

[#7]

go to document properties>triggers >choose (on open  or  on any select(ur requirement) ) and  add action >external>showinformation>write condition