Map same field value twice

[dseelam]

Hello All,

How to combine Shipped units and Order by Cancel date and create new column called booked on script level in attached QVW

Thanks,

D

[Arthur_Fong]

Maybe try joining instead of mapping table.

[Brett_Bleess]

Dinesh, the only thing I have in addition to Arthur's comment are the following Design Blog posts that may be of some further help on this one:

https://community.qlik.com/t5/Qlik-Design-Blog/Don-t-join-use-Applymap-instead/ba-p/1467592

https://community.qlik.com/t5/Qlik-Design-Blog/To-Join-or-not-to-Join/ba-p/1463102

Hopefully they help you move things forward, if you have an update, please leave that for us.

Regards,
Brett

[sunny_talwar]

I don't know if you need to do this in script only, but you can do this on the front end using set analysis

{<Series, [SERIES NAME] = P([SERIES NAME])>}

The only thing to note here is that this will be expression based and not dashboard based...

[dseelam]

HI sunny,

I need this on script level as I am using same series field all over Dashboard, I created a sample so that you will better understand.

Thanks,

D

[dseelam]

Hello Brett,

I can't use mapping table in this situation.

Thanks,

D