topic Re: Problems with set expression read from external file in QlikView

Problems with set expression read from external file

Anonymous — Wed, 07 Dec 2016 10:30:16 GMT

Goodmorning everyone.

I plugged in an external file the Set expression to use in charts.

The format is in the qvs file:

SET @ORDCLI_Mese11_Y1_ValValuta = SUM( {<ANNO={$(Previous_Year)},AREA={"ORD"},MESE={$(Mese_MM_meno11)}>} VALORE_IN_VALUTA );

SET @ORDCLI_Mese11_Y1_Val€ = SUM( {<ANNO={$(Previous_Year)},AREA={"ORD"},MESE={$(Mese_MM_meno11)}>} VALORE );

ecc

In the load script I read the formulas:

$(Must_Include=$(_DIRINCLUDE)Expressions.qvs)

In view of the variable in the document the set expression they are set with the variables indicated by ($ (Previous_Year)) and $ (Mese_MM_meno11) already valued.

If these variables change in the document in the formulas are not changed. (by slider ot other object)

In view of variables it should be given the variable and not the value it contains.

To work should be seen in the variables:

SUM( {<ANNO={$(Previous_Year)},AREA={"ORD"},MESE={$(Mese_MM_meno11)}>} VALORE )

How should I write in the external file the Set expression?

I enclose File set expression.

Thank you all.

Re: Problems with set expression read from external file

sunny_talwar — Wed, 07 Dec 2016 10:42:44 GMT

Try like this:

SET @ORDCLI_Mese11_Y1_ValValuta = SUM({<ANNO={#(Previous_Year)},AREA={"ORD"},MESE={#(Mese_MM_meno11)}>} VALORE_IN_VALUTA );

SET @ORDCLI_Mese11_Y1_ValValuta = Replace(@ORDCLI_Mese11_Y1_ValValuta,'#','$');

Re: Problems with set expression read from external file

sunny_talwar — Wed, 07 Dec 2016 10:47:47 GMT

You can also look here:

Stop Dollar Sign Expansion in the script (Escape Character ??? )

Re: Problems with set expression read from external file

Anonymous — Wed, 07 Dec 2016 11:10:14 GMT

I'm sorry but I can not make it work.
The replace him should I enter in the Script and not in external file ??
Thank you

Re: Problems with set expression read from external file

sunny_talwar — Wed, 07 Dec 2016 11:11:18 GMT

Should be part of the external file

Re: Problems with set expression read from external file

Anonymous — Wed, 07 Dec 2016 11:24:02 GMT

I inserted :the following instructions in the external file :

SET @ORDCLI_Mese11_Y1_Val€=SUM( {<ANNO={#(Previous_Year)},AREA={"ORD"},MESE={#(Mese_MM_meno11)}>} VALORE );

SET @ORDCLI_Mese11_Y1_Val€=Replace(@ORDCLI_Mese11_Y1_Val€,'#','$');

but it does not work.

Re: Problems with set expression read from external file

sunny_talwar — Wed, 07 Dec 2016 12:09:14 GMT

Either use a dollar sign expansion on the front end or you can do this:

SET @ORDCLI_Mese11_Y1_Val€ = "=Replace(@ORDCLI_Mese11_Y1_Val€,'#','$')";

Re: Problems with set expression read from external file

Anonymous — Wed, 07 Dec 2016 13:08:04 GMT

Hi, the replace is not executed and the variable formula does not exist.

Re: Problems with set expression read from external file

sunny_talwar — Wed, 07 Dec 2016 13:23:08 GMT

I guess I see what is going on... Two ways

1) Rename the First variable to something else:

SET @ORDCLI_Mese11_Y1_Val€Temp =SUM( {<ANNO={#(Previous_Year)},AREA={"ORD"},MESE={#(Mese_MM_meno11)}>} VALORE );

SET @ORDCLI_Mese11_Y1_Val€=Replace(@ORDCLI_Mese11_Y1_Val€Temp,'#','$');

2) Use this other approach

LET @ORDCLI_Mese11_Y1_Val€ ='Sum({<ANNO={$' & '(Previous_Year)}, AREA={"ORD"},MESE={$' & '(Mese_MM_meno11)}>} VALORE)';