Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Highlighted
santharubban
Contributor II

Variable not working as expected

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.

 

Tags (1)
Labels (1)
4 Replies
santharubban
Contributor II

Re: Variable not working as expected

Any ideas 

santharubban
Contributor II

Re: Variable not working as expected

Please any help on above question
Marcos_rv
Contributor II

Re: Variable not working as expected

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!!!

santharubban
Contributor II

Re: Variable not working as expected

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