trigger to select full week

[marikabi]

Hello All,

I'm loading to my Qlik View application data aggregated on a daily basis.

Based on the date i define in the loading script the WEEK_YEAR dimension

as week(Floor(DATE))&'-'&YEAR(DATE) as WEEK_YEAR   (example 14-20 )

i'm trying to set a trigger  to select only weeks made of 7 days (full weeks) when activating a sheet.

Please any idea how to set this?

thank you very much

[rubenmarin · Accepted solution]

Hi, I think you can add a flag field in script to check those full weeks, something like:

If(DATE<WeekStart(Today()), 1, 0) as isFullWeek

And use this flag to filter data selcting in trigger:

='("'&concat(distinct {<isFullWeek={1}>} WEEK_YEAR,'"|"')&'")'

[marikabi]

hello,

this is great !

I partially used your solution, without creating any flag i just triggered the selection of dates as

= '<' & WeekStart(Today())

and it works as expected!

have a nice weekend!