Displaying timescale data

[martynwb]

I have a table in Qlik that includes fields like, name, completion date, status, campaign name. for training campaigns.

I want to be able to show the percentage complete (status) over each week. However, I don't know how to set up the dimension in order to do that when I have the raw date field.

[Andre_Sostizzo · Accepted solution]

@martynwb, perhaps you can use the weekday() which returns a number 0-6, and workout a percentage for each one of these returned values. 

https://help.qlik.com/en-US/sense/August2021/Subsystems/Hub/Content/Sense_Hub/Scripting/DateAndTimeF...