topic Evaluation of SET expression variable in QlikView

Evaluation of SET expression variable

Anonymous — Fri, 30 Jan 2015 10:29:23 GMT

Hi,

I have a variable created in my application using SET keyword whose value has a special character.

Example : SET vSample='Sp-Char'

SET vSample2='SampleVal'

When I am using this variable value in my SET analysis expression it is not returning the correct value where as the another variable vSample2 is returning the proper value.

PFA sample application. In this application the set analysis expression for the value without special character is working fine(expression for text box background color) where as the variable with value without special character is not working.

Hope I am clear on my part.

Thanks in advance.

Regards,

Laxmi

Re: Evaluation of SET expression variable

alexandros17 — Fri, 30 Jan 2015 10:49:00 GMT

what are you trying to do?
First you cannot use (Sum( ...Value) if value is not numeric.
second in field description you cannot use - char, try with SP_Char
Third when you use Sum for colours choice in text boxes, which value should you use?

Hope this helps

Re: Evaluation of SET expression variable

Anonymous — Fri, 30 Jan 2015 11:33:14 GMT

Thanks for you time Alessandro Saccone.

My actual application with (Sum(.. Value) has a numeric value.

Sorry I cannot post my application as it has confidential data.

Let me explain in a different way.

I have different Business Units in my firm.

vBU1='Unit1'

vBU2='Unit2'

vBU3='Unit3'

And if a particular Business Unit has not met the target a flag will be set to -1 else it will be 0. Let this flag be BUFlag.

The text box color should be red or green based on this flag value for different Business Units. If the flag is -1 it will red or it will be green if its 0.

Condition in the textbox would be

if(SUM({<BU={$(vBU1)}>}BUFlag)=-1,red(),green())

Hope I am not confusing...

Regards,

Laxmi

Re: Evaluation of SET expression variable

avinashelite — Fri, 30 Jan 2015 11:43:06 GMT

try like this:

if(if(BU=$(vBU1),sum(BUFlag))=-1,red(),green())

Re: Evaluation of SET expression variable

rubenmarin — Fri, 30 Jan 2015 11:43:12 GMT

Hi Laxmi, You can try with:

=sum({<Value={'$(vSample)'}>}Value)

without the quotes i think qv is trying to do Sp minus Char

Re: Evaluation of SET expression variable

Anonymous — Fri, 30 Jan 2015 11:51:54 GMT

Thanks all for your reply.

This helps.

But is there any way that I can implement while setting the variable value?

Because I have hundreds of such expression where I have to make the changes. Instead I want to change the value of variable in SET.

Regards,

Laxmi

Re: Evaluation of SET expression variable

rubenmarin — Fri, 30 Jan 2015 12:09:57 GMT

Hi, try with:

SET vSample="'SP-Char'";

This a a simple-quoted text inside a double-quote.

Re: Evaluation of SET expression variable

Anonymous — Fri, 30 Jan 2015 12:15:26 GMT

have you tried in place of -1 just use

if(SUM({<BU={$(vBU1)}>}BUFlag)<0,red(),green())

Re: Evaluation of SET expression variable

alexandros17 — Fri, 30 Jan 2015 12:26:58 GMT

The problem is in

if(SUM({<BU={$(vBU1)}>}BUFlag)=-1,red(),green()) ...