topic Re: rolling week in QlikView

rolling week

Tue, 06 Oct 2015 07:10:27 GMT

My rolling 6 week logic button has this logic='("' & concat({=$(vprevweek)} distinct WeekAndYear,'"|"') & '")'

if i click on some other button click on rolling week button it wont work if i again click it works. Any idea how to resolve this.

SreeniJD — Tue, 06 Oct 2015 07:26:59 GMT

Your question isn't very clear.... are you saying that after double click on button, rolling week is claculating?

pls confirm!

Sreeni

Tue, 06 Oct 2015 07:53:37 GMT

yes ... if we double click only rolling week logic works or else with one click it does not work

sujeetsingh — Tue, 06 Oct 2015 08:14:54 GMT

Please come in more words.

Tue, 06 Oct 2015 08:54:54 GMT

could you please tel me rolling 4 weeks logic, so that i can check if my logic is incorrect

SreeniJD — Tue, 06 Oct 2015 08:57:32 GMT

Last 4 weeks Amount...

Sum({<Year=, Quarter=, Month=, Week=, Date={‘>=$(=WeekStart(Max(Date), -4))<=$(=Date(Max(Date)))’}>} Amount )

Anonymous — Tue, 06 Oct 2015 09:13:59 GMT

this is for chart expression right? i gues he wants logic for selecting last 4 or 6 weeks in selection box

Tue, 06 Oct 2015 10:26:38 GMT

yes this is for select in field trigger....could you please tel me what will be logic for selection rolling 4 or 6 weeks?