Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
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

3 Replies
tresesco
MVP
MVP

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

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!”
marcus_sommer

Here is a workaround: using ValueLoop with date

- Marcus