topic Associating UI level if possible in QlikView

Associating UI level if possible

priyarane — Mon, 30 Jul 2018 11:21:37 GMT

hi Community,

Is there any way we can associate values in front end.

For Ex:

for Lineno 129k, I need to get values of GA6(a.08,a.8a,a.08b) but at the back end it is not associate so do we have any set to get their values of GA6(a.08,a.8a,a.08b) without changing script.

added dummy data.

Re: Associating UI level if possible

sunny_talwar — Mon, 30 Jul 2018 11:23:44 GMT

You need this where? for each time the LineNo is 129k, you want to see the same number repeating?

Re: Associating UI level if possible

priyarane — Mon, 30 Jul 2018 11:28:11 GMT

not necessary, if we get like that then it is very good, else it is fine the number

Re: Associating UI level if possible

sunny_talwar — Mon, 30 Jul 2018 11:30:35 GMT

Sorry, what? I am not sure I follow you? I am not sure the kind of output you are looking to get... for the sample provided, can you provide the numerical output you are hoping to get?

Re: Associating UI level if possible

priyarane — Mon, 30 Jul 2018 11:37:00 GMT

Expecting Like this

Re: Associating UI level if possible

sunny_talwar — Mon, 30 Jul 2018 11:42:40 GMT

You can very easily get the first one like this

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

Re: Associating UI level if possible

priyarane — Mon, 30 Jul 2018 11:52:27 GMT

that is good idea, but if I drill down further for ex if I select 129k then I am getting only a.08 value only i.e 26 so do we have any other solution to keep 48 only even if I drill down

Re: Associating UI level if possible

sunny_talwar — Mon, 30 Jul 2018 11:55:38 GMT

Ignore selection in LineNo or use 1

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

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

Re: Associating UI level if possible

priyarane — Mon, 30 Jul 2018 12:09:10 GMT

Thanks Sunny for helping on it, I am getting the values as expected but when we take any other filters then our results are not correct, for ex take one more filter GA6, select a.08a then it should be value of a.08a but it is not happening.

I understand this functionality should be from backend but still trying front end as many reports will get disturb if I commint backend changes.

Re: Associating UI level if possible

sunny_talwar — Mon, 30 Jul 2018 12:14:18 GMT

Like this?

Expression

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

Re: Associating UI level if possible

priyarane — Mon, 30 Jul 2018 12:39:24 GMT

Awesome..