topic Re: grouping dimension values in QlikView

grouping dimension values

santhosh_k_n — Thu, 22 May 2014 11:13:59 GMT

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

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 — Thu, 22 May 2014 11:19:32 GMT

have a look at this example

it allows user to group product dynamically but

you can set it to be prominent

SunilChauhan — Thu, 22 May 2014 11:24:43 GMT

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

hope this helps

santhosh_k_n — Thu, 22 May 2014 11:28:13 GMT

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 — Thu, 22 May 2014 15:44:28 GMT

can you please explain bit more your requirement

MarcoWedel — Thu, 22 May 2014 16:03:22 GMT

Maybe you can customize this solution to meet your requirements?

regards

Marco

MarcoWedel — Fri, 23 May 2014 07:59:38 GMT

Table for script tests

MarcoWedel — Fri, 23 May 2014 10:44:36 GMT

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