Use of a document variable

[absekrafi]

Hi Qlikview community,

I am working on a Executive dashboard developped by someone else and I found that a variable (vVar1) is used in an expression.

I don't have a problem with the expression but I just want to understand how it's used.

I looked in Parameters-->Document proprieties-->Variables  I found that vVar1  is define like LIB_MOTIF_ABC=

what is the meaning of "LIB_MOTIF_ABC=" and is it used or not.

The expression in which vVar1 is used is:

=Sum({<DATE_T={"$(vMaxDate)"},TYPE_ART={'M'},LIB_PROD=,$(vVar1)>} QTE_MP)

Thank you in advance,

[MayilVahanan · Accepted solution]

Hi @absekrafi 

LIB_MOTIF_ABC=  <-- means ignore the selection of  LIB_MOTIF_ABC in the expression. 

Variable is use generally for 

- Reusability (We can use the variable in many expression)

- Easy to change (If we change the values, it reflect in all places)

- Less maintenance 

[absekrafi]

Hi Mayil,

Thank you for your reply.

Here there's no relation between vVar1 and LIB_PROD so do we still have to use vVar1 and set it to LIB_MOTIF_ABC= ?

thank you,

[MayilVahanan · Accepted solution]

Hi @absekrafi 

If there is no relation between LIB_MOTIF_ABC & LIB_PROD , then its not required. But confirm with user / higher person who knows about requirement.