topic Stringvariable in set analysis in QlikView

Stringvariable in set analysis

Sun, 14 Jun 2015 08:54:31 GMT

Hi,

i define a variable as: set vSC = 'GetFieldselections(Field)';

the field variables in Field are type string. The variable works and i can see in QV that its changing value (text object) when making selections in field.

i want to use this variable in set analysis, but the exppression: sum({<val={'$(=SC)'}>} "summa över")

doesent seem to work. i have tried different solutions.

Any suggestions?

Re: Stringvariable in set analysis

swuehl — Sun, 14 Jun 2015 09:25:06 GMT

Could you give some examples how the returned string from GetFieldSelections() look like? For example, how many values you are selecting, how the values look like etc. You can also try

=sum({<val = Field >} "summa över")

Re: Stringvariable in set analysis

Sun, 14 Jun 2015 09:34:43 GMT

The variable returned is a text string, i would like sum from the set analysis to depend on what values the variable SC has, eg if i make different selections in Field the sum in the set analysis will change with the selection.

Re: Stringvariable in set analysis

Anonymous — Sun, 14 Jun 2015 09:38:38 GMT

len(GetCurrentSelections(''Field'))

Re: Stringvariable in set analysis

Sun, 14 Jun 2015 09:45:38 GMT

rgv rand, how shall i use the expression? in the set analysis? can you explain further?

thanks

Re: Stringvariable in set analysis

Sun, 14 Jun 2015 10:06:28 GMT

Hi rgv rand,

can you explain further? defining the variable as tour suggestion makes it numeric (as seen in text object), but how does it work in the set analysis?

Re: Stringvariable in set analysis

swuehl — Sun, 14 Jun 2015 10:08:10 GMT

Some examples of your selections in Field and values to match in field val would be helpful. Since you are quoting your returned variable string, multiple selected values in Field would be taken as single value to match to val. Have you tried my suggested expression?

Re: Stringvariable in set analysis

Anonymous — Sun, 14 Jun 2015 10:52:07 GMT

Try like this ,

keep above code in a variable and use it set analysis

In variable overview

vLen = len(getCurrentSelections('Field'))

and use it in set analysis.

sum($(vLen))

thanks

Re: Stringvariable in set analysis

Sun, 14 Jun 2015 11:07:30 GMT

if you compare with my set analysis expression above, will sum($(vLen)) change the sum of summa över depending of choice of Field? is sum($(vLen)) the total expression?

thanks

Re: Stringvariable in set analysis

Anonymous — Sun, 14 Jun 2015 11:18:28 GMT

i think you want to find the length of string which you selected .Isn't it ?

else

elaborate your requirement

and check the variable in declaration and expression (in question )

set vSC = 'GetFieldselections(Field)';

sum({<val={'$(=SC)'}>} "summa över")

I don't think you used the same variable in expression.

Re: Stringvariable in set analysis

jagan — Sun, 14 Jun 2015 11:27:29 GMT

Hi,

If the dimension values has any spaces then this expression won't work.

Try like this

sum({<val=P(Field)>} "summa över")

vSC = chr(39) & GetFieldselections(Field, chr(39), ',', chr(39)) & chr(39)

and use below expression

sum({<val={'$(=vSC)'}>} "summa över")

Regards,

Jagan.

Re: Stringvariable in set analysis

Sun, 14 Jun 2015 17:46:25 GMT

Hi Jagan,

Still doesent work, i modified to = chr(39) & GetFieldSelection(Field) & chr(39), this gives quotes round the variable but the sum function still not functioning.

/Anders

Re: Stringvariable in set analysis

Anonymous — Sun, 14 Jun 2015 19:46:25 GMT

Hej!

I hope I understand right, maybe this work:

sum({<Val={'$(=($(vSC)))'}, Field=>} [Summa över])

I attach an example.

Hej då!

/Giuseppe

Re: Stringvariable in set analysis

jagan — Mon, 15 Jun 2015 02:18:38 GMT

Hi,

Try this

sum({<val={$(=vSC)}>} [summa över])

Regards,

Jagan.

Re: Stringvariable in set analysis

swuehl — Mon, 15 Jun 2015 07:20:58 GMT

Anders,

'still doesn't work' is not a very helpful answer to us.

Again, why don't you come up with some sample data of the two fields in question.

Using GetFieldsSelection() might finally work, but has some limitations, e.g when selecting large amounts oft values. To get potentially needed quoting correct is also not trivial.

Since you still have issues getting the expected results, why don't you come up with some sample values of these two fields involved?

And I still got no answer why my very first suggested expression, which seems IMHO most simple and robust, is not working for you:

=sum({<val = Field >} [summa över])

where Field is the field you used in GetFieldSelections() before. This should apply the selections in field Field to field val, where values are matching.

Re: Stringvariable in set analysis

Anonymous — Mon, 15 Jun 2015 07:55:16 GMT

Hi Anders,

I think (like other person) it is better if you post an example (also a qvw test file) so we can understand what you need exactly.

My example is good for you or not?

/Giuseppe

Re: Stringvariable in set analysis

sasiparupudi1 — Mon, 15 Jun 2015 14:07:05 GMT

Hi In your variable trigger,

use the following

=chr(39)& Replace(GetFieldSelections(val),', ',chr(39)&','&chr(39))&chr(39)

and the set expression should be simple

sum({<val={$(=vSC)}>} [summa över])

This should work with multi selects and values with spaces in them

Re: Stringvariable in set analysis

sasiparupudi1 — Mon, 15 Jun 2015 14:15:55 GMT

Please check the file

Re: Stringvariable in set analysis

sasiparupudi1 — Thu, 18 Jun 2015 09:01:57 GMT

Hi Anders,

Have you managed to get this working?

Sasi