topic Re: How to get each selection in different text objects in QlikView

How to get each selection in different text objects

rajat2392 — Tue, 03 Jun 2014 10:22:22 GMT

I am having a problem with this scenario. I want to show the 4 selected values separately in different text objects as in the image below. Please help how to do that. Tried too many functions but didn't get. Please help.

Regards

Rajat

Re: How to get each selection in different text objects

krishnacbe — Tue, 03 Jun 2014 10:26:06 GMT

Hi Rajat,

Unable to view the image. can you explain the Scenario in detail.

Regards,

Krishnapriya.

Re: How to get each selection in different text objects

Tue, 03 Jun 2014 10:27:19 GMT

try this:

=SubField(Concat(Country_Name,';'),';',1),

=SubField(Concat(Country_Name,';'),';',2), ....

Re: How to get each selection in different text objects

alexandros17 — Tue, 03 Jun 2014 10:28:50 GMT

When you select more than one value you have a string , check it in the text box writeing the function =GetFieldSelections(MyField)

Now, use the function

subfield(GetFieldSelections(MyField), ';' ,1) in the first textbox,

subfield(GetFieldSelections(MyField), ';' ,2) in the second and so on ... only pay attention to ;, if your full string has ; as separator than use it otherway use the that separator

Re: How to get each selection in different text objects

rajat2392 — Tue, 03 Jun 2014 10:32:04 GMT

Hi Dariusz,

This I have tired, but problem arises when I have more values in Country and more the selections.

Suppose I have around 60 values in Country, and I select 40 out of them..then it is showing "Out of Object memory"

Re: How to get each selection in different text objects

alexandros17 — Tue, 03 Jun 2014 10:35:27 GMT

Go in Settings -> User Preferences -> General and insert a value in the "Max values in current selection" box.

you will be able to see up to "That number" distinct values

Re: How to get each selection in different text objects

rajat2392 — Tue, 03 Jun 2014 10:35:43 GMT

Hi Alessandro,

Tried this already, problem comes when I have more values in Country. Suppose I have 15, and if I select 11 out of them, then it results like "NOT 'list of excluded values' "

Re: How to get each selection in different text objects

Tue, 03 Jun 2014 10:37:50 GMT

Rajat,

You told, that you have 4

i think, you may have some country_id field.

Then you may try:

FirstSortedValue(Country,country_id,text_object_nbr)

regards

Darek

Re: How to get each selection in different text objects

alexandros17 — Tue, 03 Jun 2014 10:38:05 GMT

It is strange because the bahaviour you are describing is related to what I asked to set in the box

Re: How to get each selection in different text objects

rajat2392 — Tue, 03 Jun 2014 10:40:48 GMT

Yaeh strange, but coming like this only. I have kept that limit to 50, and selecting 11, still the results are coming like this only.

Re: How to get each selection in different text objects

rajat2392 — Tue, 03 Jun 2014 10:49:51 GMT

Sorry that was a example only. This is the original one and you can see in Image what I am getting.

Re: How to get each selection in different text objects

rajat2392 — Tue, 03 Jun 2014 10:51:03 GMT

Hi Krishna

I have pasted in the post only now. Can you see it now?

Re: How to get each selection in different text objects

alexandros17 — Tue, 03 Jun 2014 10:51:59 GMT

You are right , you must use a parameter for the function, here it is:

getfieldselections (FieldName [, ValueSep [, MaxValues]])

so in MaxValues set 50 and it will work ...

Re: How to get each selection in different text objects

Colin-Albert — Tue, 03 Jun 2014 10:54:16 GMT

Why do you need the data in separate text boxes?

You could use create a QV report that contains the text box and apply banding to loop through the values in the dimension.

Re: How to get each selection in different text objects

Tue, 03 Jun 2014 10:57:11 GMT

Rajat,

but why to use those textobject?

Maybe it will be better to put some tablebox?

Re: How to get each selection in different text objects

rajat2392 — Tue, 03 Jun 2014 10:58:24 GMT

Now it is working, thank you so much.

Thanx to all for the help.

Regards

Rajat

Re: How to get each selection in different text objects

rajat2392 — Tue, 03 Jun 2014 11:00:48 GMT

Hi Colin,

Exactly I will not be using this in text box, I will have these values in the variables, and use them for expression. The number of selections made, the number of expressions by these values I will show.

Regards

Re: How to get each selection in different text objects

rajat2392 — Tue, 03 Jun 2014 11:02:17 GMT

Dariusz,

Regards

Re: How to get each selection in different text objects

Srinivas — Thu, 18 Sep 2014 14:17:30 GMT

Hi Alessandro,

Could you send sample file,that would be better to understanding functionality.

Advance Thanks

Munna