Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
On May 18th at 10AM EDT we will answer your QlikView questions live. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
subbareddykm
Creator II
Creator II

Logic required

HI All ,

I have been trying on below data to get required output since long time.

I have data like below :

 

Field
User : Kalyan
Loc:
City
Dest
Code
1001
1002
1003
1004
1005
1006
1007
User : Ravi
Loc:
City
Dest
Code
2001
1007
1004
User : Shiva
Loc:
City
Dest
Country
Code
2008
2010
2003
3289
3892

8221

I want output like below :

 

User Code
Kalyan1001
Kalyan1002
Kalyan1003
Kalyan1004
Kalyan1005
Kalyan1006
Kalyan1007
Ravi2001
Ravi1007
Ravi1004
Shiva2008
Shiva2010
Shiva2003
Shiva3289
Shiva3892
Shiva8221

Can anyone tell me how to achieve this in back end?

!

2 Replies
YoussefBelloum
Champion
Champion

Hi,

what is the rule to map the codes and the users ?

trdandamudi
Master II
Master II

May be as below: