Discussion Board for collaboration on QlikView Layout & Visualizations.
I have a date field , and i want to use script reload to create a flag_weekday field. Hope some one will advise me.
I mean when i activated the flag it will select all data from monday till friday.
How to do it ?
Try creating a field with WEEKDAY(Date) as WeekDay
Then you can select only working days, working almost like a flag.
Or you can use the expression above bu tresesco, but with the numeric value (text one will vary depending on your operational system language).
If(Weekday(Date)>=5,'Week End') as Flag
I'd first create a variable weekday through the ='WeekDay(date field)' function. This will give you a number from 1 to 7 in the variable weekday.
Then you can create the flag afterwards like 'if (weekday <> 6 and weekday <> 7, 'WEEK', 'WE')as Flag '.