topic Re: How to show variable when WeekFlag is 1 in QlikView

How to show variable when WeekFlag is 1

ashmitp869 — Wed, 06 Oct 2021 00:22:05 GMT

Hi there,

I want to show vWeekStart as 27/9/2021 and vWeekEnd as 3/10/2021 without any selection from the table below.

when the app is open....

How to show the vWeekStart when the WeekFlag is 1.

Re: How to show variable when WeekFlag is 1

MayilVahanan — Wed, 06 Oct 2021 03:22:58 GMT

Try like below

vWeekStart = Date(Min({<WeekFlag ={1}>}MDate))

vWeekEnd = Date(Max({<WeekFlag ={1}>}MDate))

Re: How to show variable when WeekFlag is 1

NageshSG — Wed, 06 Oct 2021 03:25:01 GMT

Hi @ashmitp869

You can set the variable expression as under:

vWeekStart=Max({$<WeekFlag={1}>}MDateWeekStart)
vWeekEnd=Max({$<WeekFlag={1}>}MDateWeekEnd)

Additionally, In case you want to ignore the user selection of the dates in the front end, replace the '$' above with '1' as the identifier inside the set expression above.