topic Re: Map to Fields in QlikView

Map to Fields

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

Hi Community,

I haev 2 tables

Table1: (Like Master Table) Here i have duplicate ID, but service different.

Table2:

I have created one calculated Dimension field...............

LOAD *, If(Service='ABC', 'Button1',

If(Service='BCA', 'Button2',

If(wildmatch(Service,'*Test*'), 'Button3',

If(wildmatch(Service,'*Case*'), 'Button4')))) as Button;

If i am click Button 3 , in table 2 i have to map Test record only

10001

Test

3000

If i am click Button 4 , in table 2 i have to map Case record only

10001

Case

4000

How to map these particular records..

PFA,

sunny_talwar — Wed, 09 Mar 2016 16:46:17 GMT

May be try this:

LOAD ID,

If(Service='ABC', 'Button1',

If(Service='BCA', 'Button2',

If(wildmatch(Service,'*Case*'), 'Button3',

If(wildmatch(Service,'*Test*'), 'Button4')))) as Button,

AutoNumber(ID&Pick(WildMatch(Service, '*Test*', '*Case*') + 1, 'NA', 'Test', 'Case')) as Key;

LOAD ID,

Service

FROM

[https://community.qlik.com/thread/208840]

(html, codepage is 1252, embedded labels, table is @1);

LOAD AutoNumber(ID&Pick(WildMatch(Category, '*Test*', '*Case*') + 1, 'NA', 'Test', 'Case')) as Key,

Category,

Cost

FROM

[https://community.qlik.com/thread/208840]

(html, codepage is 1252, embedded labels, table is @2);

Nagaraju_KCS — Wed, 09 Mar 2016 17:00:35 GMT

Thank You Sunny....