Group By Field Value?

Wed, 16 Feb 2011 17:29:51 GMT

Hello,

I have the following Problem.

I created a table that looks now like this:

But i want that there isnt a seperat row for each value. It schould looklike this:

KT00012 35000 12500

The script looks like this:

Table:

LOAD

"Profil.Contact No_"

AS "Nr",

("Profil.Profile Questionnaire Code" = '1_ALLG' AND Test.Profilzeilen.%LineNo >='15000'AND Test.Profilzeilen.%LineNo <='65000',Test.Profilzeilen.%LineNo) AS "Employee",

("Profil.Profile Questionnaire Code" = '1_ALLG' AND Test.Profilzeilen.%LineNo >='85000'AND Test.Profilzeilen.%LineNo <='155000',Test.Profilzeilen.%LineNo) AS "Amount"

RESIDENT

Profil;

I tried to use "GROUP BY" but it doesn´t work.

Hope you can help me!

Thanks a lot!

Group By Field Value?

llauses243 — Wed, 16 Feb 2011 18:07:52 GMT

Hi,

This is my offer (see Ta ble2)

Good luck, Luis.

topic Group By Field Value? in QlikView

Group By Field Value?

Group By Field Value?