topic Help in QlikView

Help

panipat1990 — Fri, 31 Jul 2015 06:30:57 GMT

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..

Re: Help

sorrakis01 — Fri, 31 Jul 2015 06:36:55 GMT

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

Re: Help

settu_periasamy — Fri, 31 Jul 2015 06:38:20 GMT

Try this,

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

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

Re: Help

jonathandienst — Fri, 31 Jul 2015 07:14:41 GMT

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

Re: Help

kuczynska — Fri, 31 Jul 2015 07:38:19 GMT

Hi Gourav,

Didn't you already ask this question here: Help

and here Help

What is that about?