topic Strange QV behavior in QlikView

Strange QV behavior

giakoum — Tue, 10 Jul 2012 06:59:48 GMT

Hi all.

I just wanted to concat a fields values into a variable and came accross this strange QV behavior (v11):

If I use this expression, QV hangs!! during reload (desktop edition):

Concat('OR ([Measure Name]= ' & Chr(39) & F1 & Chr(39) & ') ') as fieldListOR

If I use this one, the stupid one, it works just fine :

Replace(Concat('OR ([Measure Name]= A' & F1 & Chr(39) & ') '), 'A', Chr(39)) as fieldListOR

See attached.

The purpose is to put single quotes into the string.

Any ideas why?

vincent_ardiet — Tue, 10 Jul 2012 07:18:57 GMT

Hi,

It's amazing, my QV hangs too. And even replacing chr() with other functions like ord() or mid() produces the same phenomena. Nice bug.

But, if you first create your string and then concatenate it works, like this :

[PlanningMeasuresList]:

LOAD

Concat(DISTINCT fieldListOR) as fieldListOR ;

LOAD

' OR ([Measure Name]=' & Chr(39) & F1 & Chr(39) & ')' AS fieldListOR

Resident [MeasuresListLoadTable] ;

Regards,

Vincent

giakoum — Tue, 10 Jul 2012 07:29:42 GMT

Nice workaround Vincent!

However it is strange, isn't it? Maybe a bug or is there something we do not know?