Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
abc_18
Creator II
Creator II

Set anaylsis expression is not working

 

I am using below expression in a text box, and it's just giving me blank values:-

=sum({<[YTD-flag]={1},[XYZName]={'$(=$(=vUserXYZ))'}>}[abc_$(vCurrency_Fxx)])

Please suggest, what is causing an error

 

Labels (1)
1 Solution

Accepted Solutions
dplr-rn
Partner - Master III
Partner - Master III

then [XYZName]={'$(vUserXYZ)'} should be enough i believe. try that .

For simple variables the way you defined it should work $(=$(=vUserXYZ)). i am just wondering if the complexity of the variable and the double $ sign expansion somehow messes things up

 

View solution in original post

8 Replies
dplr-rn
Partner - Master III
Partner - Master III

How is your variable defined?

dplr-rn
Partner - Master III
Partner - Master III

i would try and define the variable with abc inside it?

i.e. instead of [abc_$(vCurrency_Fxx)]) just use $(vCurrency_Fxx_dim)

where vCurrency_Fxx_dim is 'abc_' &$(vCurrency_Fxx)

abc_18
Creator II
Creator II
Author

=sum({<[YTD-flag]={1},[XYZName]={'$(=$(=vUserXYZ))'}>}[abc_$(vCurrency_Fxx)])

In above expression, [abc_$(vCurrency_Fxx)], this variable is working fine, if I just do sum([abc_$(vCurrency_Fxx)]), I am getting values.

Issue is with [XYZName]={'$(=$(=vUserXYZ))'}

where vUserXYZ=if(GetSelectedCount([XYZ Name]) = 1,[XYZName],If(IsNull(Only({<[User]={'$(=$(vUser))'}>} Distinct [User APH])), 'Product Hierarchy structure'
,Only({<[User]={'$(=$(vUser))'}>} Distinct [User APH]))
)

 

 

dplr-rn
Partner - Master III
Partner - Master III

do you have an = in from of the expression in vUserXYZ?

abc_18
Creator II
Creator II
Author

Yes, Variable expression is define with an =

dplr-rn
Partner - Master III
Partner - Master III

then [XYZName]={'$(vUserXYZ)'} should be enough i believe. try that .

For simple variables the way you defined it should work $(=$(=vUserXYZ)). i am just wondering if the complexity of the variable and the double $ sign expansion somehow messes things up

 

abc_18
Creator II
Creator II
Author

What if I won't use an = sign in variable expression, in that case it should work?

[XYZName]={$(=$(=vUserXYZ))}

 

But even after using it, not getting proper value.

dplr-rn
Partner - Master III
Partner - Master III

it should. it does for simpler test i did