Help

[panipat1990]

Hi,

   I am new qlikview......suppose in DB 2500 Records Not Clear........Like U.K.,UNITED STATE,BRITAN,England,,or Many Countries Same repeated......USA,India,Or Many Countries Different Way of write........Then How to solve this issue in qlikview.....i donot want to use mapping..........Not Maintain Inline ........Suppose My Records 2500 Not Clear.....Then How To Solve this Issue In Qlikview without Using Mapping or inline...................please help me..

[sorrakis01 · Accepted solution]

Hi,

You can LOAD your records on qlik and work on them. Example:

If your field country can be U.K., BRITAIN, England...

You can do:

LOAD If(Country= Match(Country,'U.K.','BRITAIN','England'),'Great Britain',

          If(Country= 'USA','United States','Others Countries')) as Country

FROM (your database, excel file....)

Regards

[settu_periasamy]

Try this,

1. Concat (Distinct Country);  Assign to the variable

2. use the Pick(Match() or Wildmatch) function to group the countries.

[jonathandienst]

This is actually a scenario where a mapping is exactly what you want to use. Why do you exclude it?

[kuczynska]

Hi Gourav,

Didn't you already ask this question here: Help

and here Help

What is that about?