Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
it must be using Alternate States
Hi Saima,
I know it using Alternate State. But, at the end how the expression did?
Thanks.
Best Regards.