topic Re: PROBLEM WITH EXPRESSION in QlikView

PROBLEM WITH EXPRESSION

adiarnon — Wed, 09 Apr 2014 13:12:16 GMT

HI,

i have a table-

catalog number	month	order no	qty
a	1	1	10
a	1	2	10
b	1	3	10
c	1	4	10
c	1	5	10
c	1	6	10
d	1	7	10

i want to get a table

i have a problem with the orders nums column.

its working only if there is only one order...

can i do that somehow?

tnx...

alexandros17 — Wed, 09 Apr 2014 13:20:32 GMT

Here it is an example

adiarnon — Wed, 09 Apr 2014 13:28:27 GMT

can i do that without changing my scheme?

alexandros17 — Wed, 09 Apr 2014 13:33:20 GMT

Here it is as you want

MK_QSL — Wed, 09 Apr 2014 13:40:10 GMT

Create a straight table

Dimension = catalog number

Expression

SUM(qty)

Concat(Distinct [order no],', ')

alexandros17 — Wed, 09 Apr 2014 13:42:37 GMT

Hi Adi,

even my answer was correct ...

adiarnon — Thu, 10 Apr 2014 05:36:42 GMT

hi,

sorry, but i cant choose 2 correct answers.

next time it will be yours

MK_QSL — Thu, 10 Apr 2014 05:47:29 GMT

Hi Adi,

Honestly speaking, whenever you get more than one correct answer, try to select correct one which was posted first.

Also, if more than one answers are correct, you can select helpful also.

In this case Alessandro's answer should be selected as correct and my one as helpful.

Thanks for your understanding.

alexandros17 — Thu, 10 Apr 2014 06:37:18 GMT

Thanks Manish ... it does not matter however and I' happy you received the points!