Discussion Board for collaboration on QlikView Scripting.
I have a xls sheet when 4 weeks e.g
Week for drafting
Week for review
Week for correction
Week for approval
Can I create a week field and use the same week field to search in all of the 4 weeks in the xls?
Example if I enter week 33 then my table list would list all entries that matches week 33 for either drafting, reviewing, correction or approval?
I tried to associate all the weeks with e.g. WeekNumber but gets an error
Any good ideas?
You need to look at Canonical Calendar for your requirement. Have a look here: Canonical Date
Beautiful thanks, I'll have a look.