Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
petersvendsen
New Contributor II

Can I use the same data search for several date fields?

Hi all,

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?

Thanks

Peter

2 Replies

Re: Can I use the same data search for several date fields?

You need to look at Canonical Calendar for your requirement. Have a look here: Canonical Date

petersvendsen
New Contributor II

Re: Can I use the same data search for several date fields?

Beautiful thanks, I'll have a look.

Community Browser