New to Qlikview

[#1]

HI, I am new to Qlikview and i need help on using this software. I am doing a BI course and I am using this software.

1) I have a table with few columns "coded". Example Gender column which is using "1" as Female, "2' as Male. Do i need to create a Gender lookup table for this column? Other coded columns include Occupation, Age. Do i need to have a lookup table for each?

2) If I want to List only movies that received at least 1000 ratings, is there anything wrong with this expression : count(ratings) >= '1000' ? I tried but the results include those less than 1000 ratings.

Thanks.

Mike

[its_anandrjs]

Hi,

Try with some thing this ways

1. Use mapping table for mapping Genders is best idea

Ex:-

GenderMap:

Mapping Load * inline

[

Gender,Details

1,Female

2,Male

];

SourceTab:

Load

Applymap('GenderMap'Gender,'Unknown') as GenderDetails

From Source;

Same you can do for the rest field Occupation, Age but it not required.

2. Please elaborate more or share sample data or you can use some thing this ways

Noconcatenate

RateingCheck:

Load Distinct

MovieName,

Count(ratings) as Rate

Resident SourceTab

Group By MovieName;

Left Join(SourceTab)

Load

If(Rate >= '1000','More 1000','Less 1000') as RateCheck

Resident RateingCheck;

drop table RateingCheck;

Regards

Anand