Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Expression Question

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.

2 Replies
saimahasan
Partner - Creator III
Partner - Creator III

it must be using Alternate States

Anonymous
Not applicable
Author

Hi Saima,

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

Thanks.

Best Regards.