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.
Not applicable

Field in the ValueLoop() function

Hello all,

I would like to ask you if it possible for me to somehow have fields in ValueLoop function.

I want to create dimension that will be used as a date.

= ValueLoop(PlannedStart,PlannedEnd,1) something like this

And is it possible to format this as a date, because like this is not working: =Date(ValueLoop(42331,42341,1),'DD.MM.YYYY')

Thanks

Tags (1)
3 Replies
MVP
MVP

Re: Field in the ValueLoop() function

  • = ValueLoop(PlannedStart,PlannedEnd,1)  - is poosible provided your fields have only one value in the scope (or selected).
  • Date(ValueLoop(... - seems not working
hirishv7
Honored Contributor

Re: Field in the ValueLoop() function

Hi,

Your Dimension is ok:

ValueLoop(PlannedStart,PlannedEnd,1)


Expression should be ,


=Pick( Match(ValueLoop(PlannedStart,PlannedEnd,1) ,Date(PlannedStart,'DD/MM/YYYY'),Date(PlannedEnd,'DD/MM/YYYY'))


HTH,

Hirish


Re: Field in the ValueLoop() function

Here is a workaround: using ValueLoop with date

- Marcus

Community Browser