Variable not working as expected

santharubban — Sat, 16 Nov 2024 03:56:51 GMT

Hi All,

I have 2 variable one variable definition as below

Variable 1:

Num((($(='%Lw_AU_'&Concat(DISTINCT InputField, ','))) +
($(='%Lw_EDC_'&Concat(DISTINCT InputField, ','))) +
($(='%Lw_VSA_'&Concat(DISTINCT InputField, ','))) +
($(='%Lw_DAT_'&Concat(DISTINCT InputField, ','))) +
($(='%Lw_DS_'&Concat(DISTINCT InputField, ','))) +
($(='%Lw_TASE_'&Concat(DISTINCT InputField, ','))) +
($(='%Lw_VD_'&Concat(DISTINCT InputField, ','))) +
($(='%Lw_IE_'&Concat(DISTINCT InputField, ','))) +
($(='%Lw_VNVH_SQ_'&Concat(DISTINCT InputField, ','))) +
($(='%Lw_Weight_'&Concat(DISTINCT InputField, ','))) +
($(='%Lw_PQ_'&Concat(DISTINCT InputField, ','))) +
($(='%Lw_QHC_'&Concat(DISTINCT InputField, ','))) +
($(='%Lw_ONA_'&Concat(DISTINCT InputField, ','))) +
($(='%Lw_Safety_'&Concat(DISTINCT InputField, ','))) +
($(='%Lw_PFER_'&Concat(DISTINCT InputField, ','))) +
($(='%Lw_PRD_'&Concat(DISTINCT InputField, ',')))), '#,##0.00;(#,##0.00)')

and I am call this variable 1 in the second variable as below

($(=Concat(DISTINCT InputField, ',')) + $(Variable 1))

I am not able get variable 1 value in Variable 2

If i use ($(=Concat(DISTINCT InputField, ',')) + $(=$(Variable 1))) , I am get value but its not carrying sign (-)(+) its always positive value.

Can anyone help me.

Re: Variable not working as expected

santharubban — Fri, 05 Apr 2019 00:52:22 GMT

Any ideas

Re: Variable not working as expected

santharubban — Fri, 05 Apr 2019 13:01:56 GMT

Please any help on above question

Re: Variable not working as expected

Marcos_rv — Fri, 05 Apr 2019 13:05:40 GMT

Can you show us a table with the expected input and output info ??? and that's in the script ?? I do not understand what you want to do. Regards!!!

Re: Variable not working as expected

santharubban — Fri, 05 Apr 2019 13:08:13 GMT

Using Pivot table and Variable 2 as dimension in the pivot table

topic Re: Variable not working as expected in QlikView

Variable not working as expected

Re: Variable not working as expected

Re: Variable not working as expected

Re: Variable not working as expected

Re: Variable not working as expected