topic Re: Use of a document variable in QlikView

Use of a document variable

absekrafi — Wed, 25 Nov 2020 16:16:04 GMT

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,

Re: Use of a document variable

MayilVahanan — Tue, 20 Oct 2020 08:47:11 GMT

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

Re: Use of a document variable

absekrafi — Tue, 20 Oct 2020 09:59:34 GMT

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,

Re: Use of a document variable

MayilVahanan — Thu, 22 Oct 2020 03:16:17 GMT

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.