topic Is there a function that can return many values? in QlikView

Is there a function that can return many values?

Thu, 08 Jul 2010 14:02:54 GMT

Hello,

I have created a chart that shows all orders that have resulted in more than one invoice.

I have dimensions that state:

=If(Aggr(Count(DISTINCT InvoiceNo),OrderNo) = 2, InvoiceNo)

My problem is that only one InvoiceNo is shown and I would like my chart to display the 2 InvoiceNo's that were used.

Is there a suitable function for this?

Martin

Or — Thu, 08 Jul 2010 14:36:34 GMT

Sounds like you should be able to use the concat() function.

johnw — Thu, 08 Jul 2010 22:02:21 GMT

You could do this:

Dimension 1 = InvoiceNo
Dimension 2 = if(aggr(count(distinct InvoiceNo),OrderNo)=2,OrderNo)

Suppress dimension 2 when null, then hide dimension 2 if you really don't want to see what order numbers are associated with the invoices.