Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Community,
I haev 2 tables
Table1: (Like Master Table) Here i have duplicate ID, but service different.
ID | Service |
10010 | ABC |
10011 | BCA |
10001 | CBA (Test) |
10001 | CBA (Case) |
Table2:
ID | Category | Cost |
10010 | Samsung | 1000 |
10011 | Nokia | 2000 |
10001 | Test | 3000 |
10001 | Case | 4000 |
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,
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);
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);
Thank You Sunny....