topic Re: Store set analysis expression in the script in QlikView

Store set analysis expression in the script

anguila — Thu, 06 Sep 2012 09:57:01 GMT

Hi,

I want to store and if statement expresion (containing set analysis) into a variable in the script for the future usage in expressions in some charts.

As the expression is the same in many charts is better having the same expresion in a variable for its future modifications.

I already defined that variable in the trigger section when the script finishes its reload. But for some reasons (developement flexibility, user scalability, all params together, etc..) I have to move into the script.

So my question exactly is: "How can I set a variable with this expresion in the script?":

=if(Customer='Custom1',Only({1<IdField={TYPE1'}>} Method), Only({1<IdField={'TYPE2'}>} Method))

I tried let with no luck..

Thanks!

David.

Re: Store set analysis expression in the script

daveamz — Thu, 06 Sep 2012 10:05:10 GMT

Hi David,

Try SET vExpre = 'if(Customer='Custom1',Only({1<IdField={TYPE1'}>} Method), Only({1<IdField={'TYPE2'}>} Method))';

SET vExpre = '=if(Customer='Custom1',Only({1<IdField={TYPE1'}>} Method), Only({1<IdField={'TYPE2'}>} Method))';

I tried the first variant and it works for a simple expression as field1+field2

Regards,

David

Re: Store set analysis expression in the script

anguila — Thu, 06 Sep 2012 16:17:45 GMT

It doesn't work at all..

If I set the expression of a text object as: =vExpre the result is 'if(Customer='Custom1',Only({1<IdField={TYPE1'}>} Method), Only({1<IdField={'TYPE2'}>} Method))'

And when I try to access the value (expresion: =$(vExpre) the result is -

When I added this expression as a trigger or even as a variable, and I set the expresion of the text object as =vExpre, the result is the expresion WITHOUT quotes: if(Customer='Custom1',Only({1<IdField={TYPE1'}>} Method), Only({1<IdField={'TYPE2'}>} Method))

Any idea? I tried the both ways you said (with and without the equal).

Thanks for the reply!

Re: Store set analysis expression in the script

anguila — Thu, 06 Sep 2012 19:52:41 GMT

I solved it!

The problem was so silly.. the issue was with the single quotes of the set analysis, so I just surrounded it the expression with double quotes and it worked like a charm:

SET vExpre = "if(Customer='Custom1',Only({1<IdField={TYPE1'}>} Method), Only({1<IdField={'TYPE2'}>} Method))";

David.

Re: Store set analysis expression in the script

marcelo_7 — Fri, 30 Nov 2012 12:47:03 GMT

I have a similar problem only that my expression uses both ' and ", any ideas?

num((1 - (sum({<DATUM={">=$(v7daysBack)<=$(v1dayBack)"}>}_Brist) / (sum({<DATUM={">=$(v7daysBack)<=$(v1dayBack)"}>}_Brist)+sum({<DATUM={">=$(v7daysBack)<=$(v1dayBack)"}>}_EJ_Brist))))*100,'##,0', ',')

Re: Store set analysis expression in the script

anguila — Fri, 30 Nov 2012 13:16:20 GMT

try to replace the double quotes inside your expresion with chr(34), the same value in the ascii table.