grouping dimension values

[santhosh_k_n]

Hi Team,

Is it possible to group set of values in dimension to count it as one and rest values as each one,

for example say am having 10 models MOD1,MOD2......MOD10 and i need to show the models in a table as follows

Model	Volume
MOD1	10
MOD2	12
MOD3	10
MOD4 & MOD5 & MOD6 as MOD456	(10+5+10)=25
MOD7	12
MOD8	7
MOD9	09
MOD10	8

Please guide me.

If not can we create a dynamic table as above so that user can group the models they like

Regards,

Santhosh N

[lironbaram]

have a look at this example

it allows user to group product dynamically but

you can set it to be prominent

http://community.qlik.com/docs/DOC-6086

[SunilChauhan]

if( Model='Mode4'  or Mode='Mode5' or Mode='Mode6' ,'Mode456',Model) as New Model

hope this helps

[santhosh_k_n]

Hi Sunil,

THis works fine if this is static for all users.

But it should be user specific

so the above expression will not work

[SunilChauhan]

can you please explain bit more your requirement

[MarcoWedel]

Maybe you can customize this solution to meet your requirements?

http://community.qlik.com/docs/DOC-6076

regards

Marco

[MarcoWedel]

Table for script tests

Model	Volume
MOD1	10
MOD2	12
MOD3	10
MOD4	10
MOD5	5
MOD6	10
MOD7	12
MOD8	7
MOD9	9
MOD10	8

[MarcoWedel]

possibly like this?

enter new group name, select some models and click the "new group" button to create a new group:

hope this helps

regards

Marco