Need help in understanding the expression

[ferha_jafri]

Hello Everyone,

I came across one expression in which set analysis is used and I need help in understanding the expression ;

there is a variable used as

$(vNotDeliveredAvg({$(vYdayAverages)},{"$(vYesterdayDay)"},[DIM],$))

and the variable expansion is

=SUM( {

(

  $3< Door_Sc_Dt = $1, Door_Sc_Cd = {$(vFTDDFailCodes)} >

  +

  $3< Eo_Sc_In_Date = $1, Eo_In_Event_Cd = {$(vFTDEOFailCodes)} >

  +

  $3< Eo_Scan_Out_Date = $1, Eo_Out_Event_Cd = {$(vFTDEOFailCodes)} >

)

*

$3< Do_Delivery_Sector = P({$4}Do_Delivery_Sector) >

} MailCount)

in the expression expansion I understood $1,2,4 but I could not understand $3 ,as how it is working as [DIM] is not a field and not even a variable in the application and this expression gives value on the selection of field values of a Field as HeadOffices.

If any one know how this expression is evaluating the value please reply.

Thank you

Ferha Jafri

[jonathandienst]

I expect [DIM] is a bookmark, based on the position of $3 in the variable expression.

[ferha_jafri]

Hello Jonathan,

I have checked and it is not a book mark as I mentioned that if we select any field value in Head office field this expression will give a reference line on the bar chart , if that filed is not selected then you will not get the reference line.

[tresesco]

Could you share the qvw with sample data ?

[jonathandienst]

The location of the $3, is a set identifier location and it must be one of these:

• 1 - ignore all selections
• $ - current selections
• $1 - $9 - previous selections
• $_1 - $_9 - next selections
• A bookmark

On consideration, $3 is ambiguous, as it could be considered a parameter (DIM) or as a previous selection. I am not sure which one takes precedence.

If a set clause is invalid, it will simply be ignored (same as not being there at all). So If DIM is neither a field, variable or bookmark, then I expect it is being ignored, or being considered as a previous selection.

[ferha_jafri]

Hello ,

In the application when you select filter in DO then blue reference line is popped up in that you will see DSM passed in the variable but not sure what it is?

[simenkg · Accepted solution]

[DIM] might be an alternate state.

Go to Settings - Document properties - General and see if there is any alternate states: