topic Re: select possible month qlikview in QlikView

select possible month qlikview

techvarun — Fri, 07 Nov 2014 10:08:39 GMT

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 — Fri, 07 Nov 2014 10:13:54 GMT

Check this:

Thanks,
AS

sushil353 — Fri, 07 Nov 2014 10:16:00 GMT

Hi,

you can use set analysis to achieve the same.

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

HTH

Sushil

techvarun — Fri, 07 Nov 2014 10:59:39 GMT

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

Fri, 07 Nov 2014 11:06:10 GMT

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

techvarun — Fri, 07 Nov 2014 11:09:13 GMT

Hi I want to select in field

On OnactivatePage Trigger

Fri, 07 Nov 2014 11:13:48 GMT

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