topic Re: How to store values of previously selected fields in a variable in QlikView

How to store values of previously selected fields in a variable

Thu, 22 Oct 2015 11:44:09 GMT

Hi Qlik viewers,

I wanted to store the previously selected values of a field into a variable.

The scenario is like:

There is a list box with values A,B and C and Update button passing the selected value to the variable using getfieldselections.

When A is selected and update button is clicked. The variable will have A.

Next B is selected and update button is clicked the variable should contain A,B.

Is there a way out to retrieve previously selected value of a list box/multibox.

Thanks and regards,

Pratik

Re: How to store values of previously selected fields in a variable

maxgro — Thu, 22 Oct 2015 11:53:13 GMT

may be (previous)

Concat({$1} DISTINCT Field, ',')

Re: How to store values of previously selected fields in a variable

Thu, 22 Oct 2015 11:55:24 GMT

Sorry but didnt understand..

Re: How to store values of previously selected fields in a variable

mjm — Thu, 22 Oct 2015 12:08:17 GMT

Hello Pratik,

You can achieve this using variables from within your document, which are set under Settings > System Variables. In the document which I have attached I created a variable called vLog with the definition of

=GetFieldSelections(FieldA) & GetFieldSelections(FieldB) & GetFieldSelections(FieldC)

You can also just use this from within a text box and this keeps a log of the selections from within Fields A,B,C

If you want to look at current selections then QlikView does have a Current Selections Box.

Please look at this and if this helps resolve your question, please mark this as helpful and correct

Thanks,

Re: How to store values of previously selected fields in a variable

Thu, 22 Oct 2015 12:18:20 GMT

Thanks Mark for your quick response, but this isnt solving my purpose.

The requirement is: There is one field named FieldA ok. This Field has the values 1,2,3,4,5.

When 1 is selected the variable should have 1 when a button is clicked (behind the button the action to pass the field value in variable must be set, eg. getcurrentselections(FieldA)). Next when 2 is selected, and button is clicked the variable should have 1,2. Next when 3 is selected and button is clicked the variable should have 1,2,3. and so onn..

Regards,

Pratik

Re: How to store values of previously selected fields in a variable

mjm — Thu, 22 Oct 2015 12:23:34 GMT

Hello Pratik,

Please do look at the application which I sent you. This does exactly what you require in the text box. For your assistance I have also proved this in my screenshot attached

I've selected 1 A and 6 and the text box shows 1A6 to show all the selections which I have made

Please mark this as helpful and correct if you are happy this resolves your question

Re: How to store values of previously selected fields in a variable

Thu, 22 Oct 2015 12:26:52 GMT

But I want values to be logged for the same field Mark.

Re: How to store values of previously selected fields in a variable

vincent_ardiet — Thu, 22 Oct 2015 12:28:03 GMT

Hi,

Create an empty variable for example vconcat and an action on the button to set the content of this variable with:

='$(vconcat)'&if(len('$(vconcat)') and GetSelectedCount(FieldA)=1,',','')&FieldA

Re: How to store values of previously selected fields in a variable

Fri, 23 Oct 2015 04:51:36 GMT

Hi Vincent,

Thanks for your reply.. But those field values I gave were just for example purpose. The actual values for the field will not be of len(Field)= 1. Im still stuck..

The scenario is: I want to eliminate values from the list box, which are once selected.

Once the user selects a value from the list box, and clicks a button. On that button I want to pass an action which will remove the selected value from the list box. That is the reason I wanted the previously selected values to be stored in a variable.

gwassenaar‌

Regards,

Pratik

Re: How to store values of previously selected fields in a variable

vincent_ardiet — Fri, 23 Oct 2015 05:26:12 GMT

Hi,

There is not problem in my expression with len(Field)>1.

It will do what you've initially asked for: to store each selection one by one in the selected order in string.

Then, to achieve your new requirement, removing from the list box the values previously selected you can do like this:

- Create another empty variable vconcatSA

- Add a second trigger on FieldA which affect vconcatSA with the following expression:

='$(vconcatSA)'&if(len('$(vconcatSA)') and GetSelectedCount(FieldA)=1,',','')&'|'&FieldA&'|'

- Then use the following expression in your listbox instead of directly FieldA:

=aggr(only({<FieldA=>-<FieldA={<$(=replace('$(vconcatSA)','|',chr(39)))>} FieldA),FieldA)

Regards,

Vincent

Re: How to store values of previously selected fields in a variable

vincent_ardiet — Fri, 23 Oct 2015 06:02:58 GMT

And if you want to let your users pick multiple values and also not do destroy the string when the clear button is pressed, change the following expressions:

First trigger on FieldA to assign vconcat:

='$(vconcat)'&if(GetSelectedCount(FieldA)>0,if(len('$(vconcat)'),',','')&concat(distinct FieldA,','))

Second trigger on FieldA to assign vconcatSA:

='$(vconcatSA)'&if(GetSelectedCount(FieldA)>0,if(len('$(vconcatSA)'),',','')&'|'&concat(distinct FieldA,'|,|')&'|')

Regards,

Vincent

Re: How to store values of previously selected fields in a variable

Fri, 23 Oct 2015 06:18:21 GMT

Hi Vincent thanks for your reply again.

But its not giving me the desired results.

When nothing is selected vconcat is blank and vconcatSA is blank, then when i select 1 from FieldA, vconcat has 1,1 and vconcatSA has |1|,|1| and so on..

And upon using the aggr expresion in list box expression it gives blank. No values are populated in the list box.

Can u post the qvw in which you got the results, maybe I am missing some steps.

Regards,

Pratik

Re: How to store values of previously selected fields in a variable

vincent_ardiet — Fri, 23 Oct 2015 06:33:44 GMT

Here it is.

Re: How to store values of previously selected fields in a variable

Fri, 23 Oct 2015 06:49:13 GMT

Hi Vincent you qvw is the exact solution which I am looking for. Thanks alot.

The list box expression is working now, idk why but earlier it gave an error in expression. I copied yours and changed the field values this the list box popped up with values.

But I am unable to see your variable expressions. for cumul and cumul2.

Can you please paste them here.

Thanks,

Pratik

Re: How to store values of previously selected fields in a variable

Fri, 23 Oct 2015 07:19:16 GMT

vincent.ardiet‌

Re: How to store values of previously selected fields in a variable

vincent_ardiet — Fri, 23 Oct 2015 07:28:17 GMT

Pratik,

cumul and cumul2 are just used to store the result.

The trigger actions on field col3 are using expressions to build them (see document properties/triggers/field event triggers).

Re: How to store values of previously selected fields in a variable

Fri, 23 Oct 2015 07:35:08 GMT

Thanks Alot Vincent!