Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Grouping data in qlikview

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?

1 Solution

Accepted Solutions
swuehl
MVP
MVP

LOAD

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

...

or

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

View solution in original post

5 Replies
dmohanty
Partner - Specialist
Partner - Specialist

If loading from QVD, use like this:

Load

A,

B,

C & D & E as C

from XYZ.qvd (qvd);

If loading from Database, use like this:

Load

A,

B,

C || D || E as C

from tablename;

Not applicable
Author

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?

jagan
Luminary Alumni
Luminary Alumni

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.

swuehl
MVP
MVP

LOAD

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

...

or

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

Not applicable
Author

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.