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.
MVP
MVP

Difference in mapping between Map..Using and ApplyMap

Hi all,

I recently came across something I haven't really understood so far, still trying, so maybe someone can point me in the right direction.

There seems to be a difference in the behaviour of MAP ... USING compared to APPLYMAP when mapping a dual value.

MAP...USING seems not to map correctly, i.e. only the numeric part.

Please check attached sample file, where I've provided two buttons to switch between the two mapping methods.

I am aware that MAP...USING compared to APPLYMAP applies the mapping at different point in time, but I don't understand the difference in dual value mapping so far. Especially since other posts seem to show this working (like rwunderlich‌ suggested something similar here).

Personally, I am not 100% sure if I have seen this working before, it seems I am more friend of the ApplyMap() function.

Tested in two different versions, latest 11.20 SR11 x64.

Regards,

Stefan

1 Solution

Accepted Solutions

Re: Difference in mapping between Map..Using and ApplyMap

Go into Document Properties, Number pane. Select the "TwoMonthPeriodNameDual" and uncheck "Survive Reload". And then reload.

-Rob

4 Replies

Re: Difference in mapping between Map..Using and ApplyMap

Go into Document Properties, Number pane. Select the "TwoMonthPeriodNameDual" and uncheck "Survive Reload". And then reload.

-Rob

MVP
MVP

Re: Difference in mapping between Map..Using and ApplyMap

Thanks a ton Rob for this!

I just created a new QVW with only the MAP..USING part, to make sure that what I've seen is not an artefact of the demo using both methods.

It seems to work (after first reload one needs to uncheck that setting), still - I am not sure if I understand why one needs to change this. Is this your standard work when you MAP ..USING duals?

Any more hints or ideas?

Regards,

Stefan

Re: Difference in mapping between Map..Using and ApplyMap

My best answer is "I don't know". I use MAP USING often, sometimes with dual(), and have never seen this problem. I've rewrote your example several ways to see if I can figure out the difference, but have not found it.

-Rb

MVP
MVP

Re: Difference in mapping between Map..Using and ApplyMap

We should set a good example and close this long-open thread...

I haven't fully understood the issue, but Rob's solution fixed it.

Community Browser