topic Re: Get list box for a Straight table Expression in QlikView

Get list box for a Straight table Expression

Wed, 25 Nov 2020 16:16:04 GMT

Hi,

I have a Straight table with ID and an Expession, I want to select the values in the expression by creating a list box. But Is it possible, I have tried it and attached is the QVW but it is displaying null when I use same expression in List Box. Please help on this.

Re: Get list box for a Straight table Expression

Tue, 18 Apr 2017 23:15:29 GMT

Hi,

As a quick and dirty I have added your expression to the list box but not sure if it does the trick for you, see qvw attached.

Warm regards,

Nish

Re: Get list box for a Straight table Expression

Wed, 19 Apr 2017 01:45:32 GMT

Hi Nish,

Thanks for the answer, Is there a way we can get only 1 and 0 as single selection with out the ID's in the List Box. Please let me know.

Regards,

Srihari.

Re: Get list box for a Straight table Expression

Anil_Babu_Samineni — Wed, 19 Apr 2017 01:59:30 GMT

May be create Flag for that or use Island table to mapping

Re: Get list box for a Straight table Expression

Wed, 19 Apr 2017 02:31:18 GMT

Hi Anil,

Actually I am giving as Expression in the Straight table, So I don't think we can map the values to an expression, we can map with dimension but not sure how we map with an expression. I tried to create the data island but I am calculating the field on the fly as an expression, so it may not be possible.