topic Re: Possible values in QlikView

Possible values

gireesh1216 — Wed, 25 Nov 2020 16:16:04 GMT

Hello Team,

I have three fields in below table like ID,S_ID and M_ID.

IF I select ID =10 in list box , I want output in text object like 4,5,10

IF I select ID =11 in list box , I want output in text object like 4,5,6,10

I have data like below:

Load * inline [

ID,S_ID,M_ID

1,4,7

2,5,8

3,6,9

4,10,11

5,10,11

6,10,11

10, ,11

11,

];

Thanks

Gireesh

shiveshsingh — Fri, 02 Feb 2018 09:43:24 GMT

The value which you want to display in textbox is S_ID??

ruanhaese — Fri, 02 Feb 2018 09:54:27 GMT

Try the CONCAT function

=concat(ID,'-')

gireesh1216 — Fri, 02 Feb 2018 09:57:12 GMT

Not working..

If I select 10 in ID filter, I want 4,5,6 output

ruanhaese — Fri, 02 Feb 2018 10:34:51 GMT

Not sure why yours doesnt work.

Just loaded your table in to the editor and added a listbox and a text object with the Concat

gireesh1216 — Fri, 02 Feb 2018 11:01:51 GMT

Nooo..This is normal condition.

Your selected S_ID filter.I don't want this filter.

Use ID filter and select 10 ..I WANT SAME RESULTS LIKE ABOVE.

gireesh1216 — Fri, 02 Feb 2018 11:21:10 GMT

Finally got solution:

this expression working fine:

=Concat({1<M_SID=p(ID)>}SID,',')