topic Re: need help in QlikView

need help

Wed, 25 Nov 2020 16:16:04 GMT

Hi,

Pls help me on this scenario

Load*

Inline[

name, val

A, 10

B, 20

C, 30

];

If I select A then result should be 40(A+C)

B--->50(B+C)

C---->30(C)

I tried with set operators but didn't work properly.

Re: need help

sunny_talwar — Tue, 02 Aug 2016 16:32:38 GMT

May be this:

Sum({name += {'C'}}Val)

=Sum({<name += {'C'}>}val)

Re: need help

Tue, 02 Aug 2016 16:46:38 GMT

Sunny It showing like this pls have look at

Re: need help

sunny_talwar — Tue, 02 Aug 2016 16:48:54 GMT

This showing that expression editor doesn't understand the syntax. Have you tried clicking ok and checking the result?

Re: need help

Tue, 02 Aug 2016 16:52:44 GMT

Yes I got the result.. But why it didn't recognise the expression?Any idea?

Re: need help

sunny_talwar — Tue, 02 Aug 2016 16:55:54 GMT

I won't be able to comment on why it isn't recognized, but I know the more recent versions of Qlik View does recognize the syntax. I have QV12 SR4 and it seems to work well for me

Re: need help

Tue, 02 Aug 2016 16:59:38 GMT

ThankQ Sunny for response.