Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
santharubban
Creator III
Creator III

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.

 

Labels (1)
4 Replies
santharubban
Creator III
Creator III
Author

Any ideas 

santharubban
Creator III
Creator III
Author

Please any help on above question
Marcos_rv
Creator II
Creator II

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
Creator III
Creator III
Author

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