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

Association - UI Level

Hi Community,

Currently I am using below expression to associate of non associated values(GA 6- 'A.08', 'A.08a', 'A.08b')  to lineno 129K. This working perfectly but now with only dimension of Lineno but now we are adding other dimensions  as well then it is not working as expected. Can any one please advise on this.

If(Only({1}LineNo) = '129k', Sum(TOTAL {<GA6 *= {'A.08', 'A.08a', 'A.08b'}, LineNo>} BSAmount), Sum(BSAmount))


Refer: Associating UI level if possible this to have more clarity on this.


_Priya

3 Replies
jyothish8807
Master II
Master II

Can you try like  this:

If(Only({1}LineNo) = '129k', Sum(TOTAL {<GA6 *= {'A.08', 'A.08a', 'A.08b'}, LineNo, NewDimension>} BSAmount), Sum(BSAmount))


Br,

KC

Best Regards,
KC
jyothish8807
Master II
Master II

Or let us know what is the new dimension you are adding, a sample will be helpful.

Br,

KC

Best Regards,
KC
priyarane
Specialist
Specialist
Author

there are couple of dimension(50+)

still this expression is not helped.

If(Only({1}LineNo) = '129k', Sum(TOTAL {<GA6 *= {'A.08', 'A.08a', 'A.08b'}, LineNo, NewDimension>} BSAmount), Sum(BSAmount))