Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
If you are a Qlik Insight Bot user, join this collaborative group: JOIN GROUP
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
Highlighted
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
Highlighted
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


HirisH
“Aspire to Inspire before we Expire!”
Highlighted
MVP & Luminary
MVP & Luminary

Re: Field in the ValueLoop() function

Here is a workaround: using ValueLoop with date

- Marcus