topic Re: Mapping Key in QlikView

Mapping Key

karunaramteke — Wed, 25 Nov 2020 16:16:04 GMT

Can anybody help me to get single key for Recon_No : 39638874-1

I want %RECEIPT_KEY as MD082001921098 and bank deposit amount 59639 in one row .

In chart it should show me %RECEIPT_KEY as MD082001921098 not 240820-59639
I had used apply map and tried to solve it.
Can anybody help me to get single key for %RECEIPT_KEY MD082001921098

I had attached a qvw and excel for reference.

Re: Mapping Key

karunaramteke — Mon, 26 Oct 2020 10:25:42 GMT

Nobody can help me in this ??

Re: Mapping Key

Kushal_Chawda — Mon, 26 Oct 2020 11:02:15 GMT

@karunaramteke Based on what logic you have applied you won't get single value. What is the logic to get the single value?

Re: Mapping Key

karunaramteke — Mon, 26 Oct 2020 11:19:28 GMT

if we apply vlookup in excel we get the value

Please check Column C:3 in sheet1 (C column is Derived column.)

Re: Mapping Key

Kushal_Chawda — Mon, 26 Oct 2020 11:59:53 GMT

@karunaramteke see the attached

Re: Mapping Key

karunaramteke — Mon, 26 Oct 2020 14:44:46 GMT

@Kushal_Chawda Thank you so much