topic Re: Grouping in QlikView

Grouping

Tue, 07 Jul 2015 13:58:39 GMT

Good Day,

I have a list of Products such as FBP, TCP, TRI, TRO ect.

Please advise how I can group this 2 by 2 and name it

eg. FBP + TCP = Passports

TRI + TRO = Travel

RFG = Person

I would then like to use these names in my list box to select what I am looking for. So instead of having 18 different products, i will now have a list of 9 using only the grouping names.

Thank you.

Re: Grouping

stigchel — Tue, 07 Jul 2015 14:01:49 GMT

You can do this best in load script e.g. using a mapping load, something like

MyMap:

Mapping load [From, To

FCB, Passports

TCP, Passports

TRI, Travel

....

];

Load

....

Product

Applymap('MyMap',Product) as MyGroup

....

From Source

Re: Grouping

stigchel — Tue, 07 Jul 2015 14:02:20 GMT

Re: Grouping

johngouws — Tue, 07 Jul 2015 14:06:04 GMT

Hi Yolanda,

You can do it either on the Load side or if you are using SQL, on the SQL Select side.

Do you have a sample to post?

Regards - John

Re: Grouping

Thu, 09 Jul 2015 12:49:28 GMT

Thank you so much!

Even though I used what says “Don’t use” It works and that’s the result I was looking for ☺

Re: Grouping

stigchel — Thu, 09 Jul 2015 12:56:03 GMT

You're welcome Yolanda

If any of this has answered your question, could you please mark the relevant answer as correct (and/or helpfull)?

Marking answers correct will close the thread, help others finding correct answers for similar problems and let other contributing members know this requires no more attention.

Thanks, Piet Hein

Re: Grouping

Wed, 15 Jul 2015 06:43:59 GMT

Hi Piet,

Where do I mark it?

Re: Grouping

stigchel — Wed, 15 Jul 2015 08:36:14 GMT

There should be a correct button in each post, which you can click to mark the answer correct. Helpful answers are set using the actions drop down beneath each post and click helpful