topic Re: Grouping data in qlikview in QlikView

Grouping data in qlikview

Wed, 13 Feb 2013 15:20:15 GMT

I have a lot of data in my qlikview project, have been told I know need to group some of it, I dont want to reimport it so what is the easiest way to do so, within my project?

so i.e data has values A, B, C, D, E

I want to return it within a graph etc so i get A,B and then (C,D,E) as C

Im struglling on how I can do this? does anyone know please?

Re: Grouping data in qlikview

dmohanty — Wed, 13 Feb 2013 15:27:22 GMT

If loading from QVD, use like this:

Load

C & D & E as C

from XYZ.qvd (qvd);

If loading from Database, use like this:

Load

C || D || E as C

from tablename;

Re: Grouping data in qlikview

Wed, 13 Feb 2013 15:30:54 GMT

Thanks for the quick response

Probably I wasnt that clear, or maybe im just been stupid.

But its not fields within the data is actually data within a field,

so I have a field called markets and then

a.ftse 250

b.International companies

c.private equity

d.private companies

and when i select my markets field as a dimension in a graph I want to be able to create a C field within Markest that is grouping my private markets together so I just have three options within my dimension?

Re: Grouping data in qlikview

jagan — Wed, 13 Feb 2013 15:43:24 GMT

Hi,

Add new Inline dimension table with the following values

Mapping:

LOAD * INLINE [

Value, ValueID

A, 1

B,1

C,2

D,2

E,2

];

Now use ValueID as dimension in your chart.

Regards,

Jagan.

Re: Grouping data in qlikview

swuehl — Wed, 13 Feb 2013 15:45:47 GMT

LOAD

if(Markets like 'private*', 'Private Market', Markets) as Markets,

...

LOAD

if(match(Markets,'private equity','private companies'),'Private Markets',Markets) as Markets,

...

Or look into using a Mapping Table in QV (check the MAPPING LOAD prefix and applymap() in the Help).

Re: Grouping data in qlikview

Thu, 14 Feb 2013 10:10:41 GMT

Thanks for all the help.

I figured it out I just had to use a calculated dimension,

=if(Customer_type='a. FTSE 100',text('a. FTSE100')........

was pretty long expression but has done the job.