Expression Question

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

Hi All,

Currently, I refer one application created by previous staff and facing some issue on the expression syntax in certain object. Can anyone explain to me what expression actually did?

The following is expression in the chart:

Count($(vExp$(=vCustomer)G1([Transaction ID])))

vCustomer = variable that allow user to choose 'Sender' or 'Receiver'. In this case, let me set the assumption for the vCustomer = 'Sender'

[Transaction ID] = field already load into QlikView

As my understanding in QlikView, after the user select 'Sender' for the vCustomer, the expression will change to the following syntax:

Count($(vExpSenderG1([Transaction ID])))

And I have a following variable in my QlikView application

vExpSenderG1 = variable that contain value : {$<[Sender Name]=$::[Sender Name],[Receiver Name]=>}$1

[Sender Name] = field already load into QlikView

[Receiver Name] = field already load into QlikView

Can I interpret the expression is doing the count of the "[Transaction ID]" where the "[Sender Name]" is equal to "[Sender Name]" in current selection but with selection in "[Receiver Name]" removed?

Based on my understanding, the $ symbol means that current selection and $1 means previous selection. Anyone can explain to me why the expression need $ at the first position and $1 at the end of the expression?

Thanks for help.

Best Regards.

Re: Expression Question

saimahasan — Wed, 24 Aug 2016 10:05:54 GMT

it must be using Alternate States

Re: Expression Question

Anonymous — Thu, 25 Aug 2016 01:02:43 GMT

Hi Saima,

I know it using Alternate State. But, at the end how the expression did?

Thanks.

Best Regards.

topic Re: Expression Question in QlikView

Expression Question

Re: Expression Question

Re: Expression Question