Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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..
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
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
Try this,
1. Concat (Distinct Country); Assign to the variable
2. use the Pick(Match() or Wildmatch) function to group the countries.
This is actually a scenario where a mapping is exactly what you want to use. Why do you exclude it?