topic Current Selection to a variable not showing all values in QlikView

Current Selection to a variable not showing all values

Fri, 05 Aug 2016 13:40:48 GMT

I created a variable to get values of a field from current selection. If the count of values selected are 6 then it's showing all selected values. If selected values more than 6 then it shows 7 out of n (like 7 out of 30). Not sure where to change the settings. I already made user preference setting of current selection box.

Settings-->User Preference-->Max values in Current Selection Box: made to 30

All values are showing in Current Selection box but not showing in Variable.

Can somebody help me?

Thanks

Abhik

Re: Current Selection to a variable not showing all values

marcus_sommer — Fri, 05 Aug 2016 16:52:29 GMT

You need to adjust the third parameter of:

getfieldselection(field, delimiter, MaxNumberOfValues)

Alternatively you could also use concat(distinct field).

- Marcus

Re: Current Selection to a variable not showing all values

maxgro — Fri, 05 Aug 2016 18:50:48 GMT

Re: Current Selection to a variable not showing all values

Mon, 08 Aug 2016 05:06:18 GMT

Thank you very much Marcus and Massimo.... It really helps. Works perfect.

Re: Current Selection to a variable not showing all values

oknotsen — Mon, 08 Aug 2016 09:35:50 GMT

If your question is now answered, please flag the Correct Answer (via the big "Correct Answer" button near every post).

If not, please make clear what part of this topic you still need help with .

Re: Current Selection to a variable not showing all values

Tue, 09 Aug 2016 09:06:07 GMT

Hello, I dont see the option to mark "Correct Answer". I only see Actions button wherein only "Helpful" Option appears. I already marked the posts as "Helpful"

Do let me know if you have any question.