Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
The #1 reason QlikView customers adopt Qlik Sense is a desire for a modern BI experience. Read More
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor II
Contributor II

Mapping data with its category

Hi all,

I have to column one is TYPE and CATEGORY and i want to map type with category .

Excel data Source

TypeCategory
10category1
20category1
40category2
30category1
60category3
70category3
80category2
90category2

 

I tried doing this using IF condition .

IF(wildmatch(Type,'10'), 'category1') as xyz

and also dont want to use pick function.

but i have N number of records to map. There is any other alternative to achieve this.

  

 

Labels (3)
1 Solution

Accepted Solutions
Highlighted
Creator III
Creator III

Im sorry i dont have any link that i can provide. You can follow the steps:

1. Create a mapping file in excel.

2. Load the file in your qvf.

3.  Left join this table to the table you need the category.

I hope this help!

View solution in original post

5 Replies
Highlighted
Creator III
Creator III

Hi,

 

What is the mapping logic? As in what is the logic of mapping between Type and Category?

Highlighted
Contributor II
Contributor II

its simple.
if value is 10,20,30 it will fall in category1
if value is 40,80,90 it will fall in category2
Highlighted
Creator III
Creator III

Im not sure i understood your issue completely, but there multiple are ways of doing,

1. Use nested if statement.

2. Create a mapping file in excel and join accordingly

Highlighted
Contributor II
Contributor II

2. Create a mapping file in excel and join accordingly
can you plz provide any link . how to map excel
Highlighted
Creator III
Creator III

Im sorry i dont have any link that i can provide. You can follow the steps:

1. Create a mapping file in excel.

2. Load the file in your qvf.

3.  Left join this table to the table you need the category.

I hope this help!

View solution in original post