topic Re: default in QlikView

default

Mon, 05 Oct 2015 11:31:14 GMT

Hi Guys,

is there any issue with rolling 6 weeks logic of mine. it works fine sometimes and sometimes does not work

='("' & concat({<MonthAndYearID={">=$(vprevweek)<=$(curweek)"}>} distinct WeekAndYear,'"|"') & '")'

$(vprevweek)=max(MonthAndYearID)-20
$(curweek)=max(MonthAndYearID)-17

Same logic works when i click the button of rolling 6 weeks but on open of document i kept same logic so that on open of my dashboard rolling 6 weeks get selected. but it does not work there. any idea?did you face any such issues with rolling week concepts?

Re: default

Anonymous — Mon, 05 Oct 2015 11:37:25 GMT

When you say ".... on open of document.... " does that mean you are using On Open triggers ?

If so and you are using the AJAX client, then do be aware that On Open triggers may not work.

Re: default

Mon, 05 Oct 2015 11:59:40 GMT

it does not work in desktop version

Re: default

Mon, 05 Oct 2015 13:05:36 GMT

on double clicking only rolling 6 weeks button works, on single click it shows wrong value

Re: default

Anonymous — Mon, 05 Oct 2015 13:57:18 GMT

what is the logic of rolling 4 weeks?