topic GetFieldSelections eqvivalent for Possible Values? in QlikView

GetFieldSelections eqvivalent for Possible Values?

Fri, 12 Aug 2011 15:11:14 GMT

If I've got a listbox for OrderID I Can access the order ID that ive choosen via getFieldSelections. At the same time when I choose an order ID i will filter down the listbox containing OrderDate so that it only holds one possible value. Since I haven't explicitly selected that OrderDate in the listbox I can't use getFieldSelections() to get the order date. Any ideas how to get the date so that I for example can store it in a variable.

best regards

GetFieldSelections eqvivalent for Possible Values?

erichshiino — Fri, 12 Aug 2011 15:17:16 GMT

Hi,

you can use:

Concat ( distinct OrderID, ',') where ',' is a separator for the field values

Regards,

Erich

GetFieldSelections eqvivalent for Possible Values?

Tue, 16 Aug 2011 07:45:32 GMT

Thanks for replying!

I can't actually make it work, got a listbox named SalesOrderNumber and made selections in other listboxes so that SalesOrderNumber holds 4 possible values. Created a text object with expression:

=Concat(DISTINCT SalesOrderNumber, ',');

The text object just shows "-". Ideas?

GetFieldSelections eqvivalent for Possible Values?

Tue, 16 Aug 2011 08:29:43 GMT

My bad, I've added a semicolon at the end of the line by habbit, It works great, thanks Erich!