topic Re: trigger to select full week in QlikView

trigger to select full week

marikabi — Sat, 16 Nov 2024 00:29:18 GMT

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 — Fri, 12 Jun 2020 17:13:05 GMT

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 — Fri, 12 Jun 2020 17:47:14 GMT

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!