topic Re: Map same field value twice in QlikView

Map same field value twice

dseelam — Sat, 16 Nov 2024 02:01:05 GMT

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,

Arthur_Fong — Thu, 07 Nov 2019 01:50:55 GMT

Maybe try joining instead of mapping table.

Brett_Bleess — Tue, 12 Nov 2019 14:44:03 GMT

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:

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

Regards,
Brett

sunny_talwar — Tue, 12 Nov 2019 15:01:37 GMT

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 — Wed, 13 Nov 2019 15:41:14 GMT

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,

dseelam — Wed, 13 Nov 2019 15:42:48 GMT

Hello Brett,

I can't use mapping table in this situation.

Thanks,