How to create a key for all and one in qlik

[Rajkumar]

Hi all,

How to create key for all and one  in qlik . Below i have given the example.

Table 1:

PRODUCT

TV

MOBILE

AC

WM

Table 2:

COUNTRY  ,PRODUCT

INDIA ,   ALL

UAE ,  MOBILE

JAPAN  ,  AC

How do i link below table in qlik ?

thanks in advance.

[Vegar]

Try using Star is to solve your issue.

Star is 'ALL';
[Table 1]:
LOAD * inline [
PRODUCT
TV
MOBILE
AC
WM
];

[Table 2]:
LOAD * 
INLINE [
COUNTRY,PRODUCT
UAE,MOBILE
JAPAN,AC
INDIA,ALL];
Star is;