topic Re: Group distinct values in QlikView

Group distinct values

Wed, 08 Jun 2016 14:49:21 GMT

Good morning, I have this problem:

I have two fields in a table. In a column there is a code (for example OLX111, SDO123, etc.) and in the second column is the amount.
How can I group the values of the first column? I would group them for the first three characters.

Regards

Re: Group distinct values

sunny_talwar — Wed, 08 Jun 2016 14:53:24 GMT

May be like this:

Dimension:

Left(code, 3)

Expression:

Sum(Amount)

Re: Group distinct values

Clever_Anjos — Wed, 08 Jun 2016 14:54:16 GMT

Something like this?

LOAD

LEFT(Code,3) as NewCode,

Sum(Ammount) as SumAmmount

Resident yourtable

Group by LEFT(Code,3) ;

Re: Group distinct values

Wed, 15 Jun 2016 10:45:38 GMT

Thanks Cleber, it's work correctly.

Re: Group distinct values

Wed, 15 Jun 2016 10:46:03 GMT

Thanks Sunny, it's ok.