topic Re: Association - UI Level in QlikView

Association - UI Level

priyarane — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: Association - UI Level

jyothish8807 — Fri, 28 Sep 2018 12:18:31 GMT

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,

Re: Association - UI Level

jyothish8807 — Fri, 28 Sep 2018 12:20:19 GMT

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

Br,

Re: Association - UI Level

priyarane — Fri, 28 Sep 2018 12:55:51 GMT

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