topic Re: String value in variable in QlikView

String value in variable

Peony — Mon, 13 Nov 2017 07:24:56 GMT

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?

Re: String value in variable

Peony — Mon, 13 Nov 2017 08:07:18 GMT

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

Anil_Babu_Samineni — Mon, 13 Nov 2017 09:14:10 GMT

Read this The Little Equals Sign

Re: String value in variable

Peony — Mon, 13 Nov 2017 15:08:14 GMT

Thank you. It's more clear now.