topic Re: Need help in understanding the expression in QlikView

Need help in understanding the expression

ferha_jafri — Fri, 09 Oct 2015 05:09:42 GMT

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

Re: Need help in understanding the expression

jonathandienst — Fri, 09 Oct 2015 05:20:24 GMT

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

Re: Need help in understanding the expression

ferha_jafri — Fri, 09 Oct 2015 05:28:51 GMT

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.

Re: Need help in understanding the expression

tresB — Fri, 09 Oct 2015 05:43:41 GMT

Could you share the qvw with sample data ?

Re: Need help in understanding the expression

jonathandienst — Fri, 09 Oct 2015 05:59:09 GMT

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.

Re: Need help in understanding the expression

ferha_jafri — Fri, 09 Oct 2015 10:03:55 GMT

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?

Re: Need help in understanding the expression

simenkg — Fri, 09 Oct 2015 11:56:12 GMT

[DIM] might be an alternate state.

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