Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
harish_meda
Contributor II
Contributor II

Dynamic Firstweekday value change

Hi All,

I want to display a dynamic week start as per user selection in charts and tables. Default first day begins =0,(Sunday).

but here I need to provide the drop-down selection for weekdays and the user needs to choose the value 0 to 6 dynamically and weekstart from that day(Monday,saturday,Sunday)

Example:

Default: Firstweekday=0(sunday)

User selection either Firstweekday=6 (Monday) or firstweekday=5 (Saturday). This choice should pass through variables and automatically weekstart should pickfrom that day.

 

Labels (1)
1 Solution

Accepted Solutions
Or
MVP
MVP

Weekstart() accepts a First week day parameter, as per the documentation..

Weekstart(YourDate,0,YourVariable)

https://help.qlik.com/en-US/qlikview/April2020/Subsystems/Client/Content/QV_QlikView/Scripting/DateA...

View solution in original post

1 Reply
Or
MVP
MVP

Weekstart() accepts a First week day parameter, as per the documentation..

Weekstart(YourDate,0,YourVariable)

https://help.qlik.com/en-US/qlikview/April2020/Subsystems/Client/Content/QV_QlikView/Scripting/DateA...