Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

kitjupitera
Contributor

String value in variable

I have set of some numbers in the field "Num_Set": 10 01, 10 02 , 10 03, 10 04, 10 05. Every number is a string value, cause of space between first pair and second pair of digits.

I need to select maxsimum number from the set (10 05) and assign the result into the variable: v_num_set = MaxString([Num_Set]).

Next step is to use this variable in "Actions - Select in field" for some text object. When I click on this object it should be autoselection in the field "Num_Set" .

So I set in text object's "Actions" field "Num_Set" and as the "Search String" set variable = $(v_num_set).

But as the result, nothing is selected.

If I replase $(v_num_set) by MaxString([Num_Set]) - everything works.

Can any one explaint to me why is it so?

1 Solution

Accepted Solutions

Re: String value in variable

3 Replies
kitjupitera
Contributor

Re: String value in variable

I find out that it because in Variable Overview I set formula as "= MaxString([Num_Set])". When I removed "=" and left just  "MaxString([Num_Set])" - it works.

But I still don't get in what case it is neded to write"=" and when it's don't.

Re: String value in variable

kitjupitera
Contributor

Re: String value in variable

Thank you. It's more clear now.

Community Browser