topic Re: Parameter variable-blank chart in QlikView

Parameter variable-blank chart

Wed, 25 Nov 2020 16:16:04 GMT

Hi,

I have defined below parameter variable which I am trying to use in chart but my chart is appearing blank

eDeparturesPerformed_VarUnit= Sum([# Departures Performed]) /$1

Dimension used in Chart : [Carrier Group]

Expression used in Chart: =$(eDeparturesPerformed_VarUnit(1))

Re: Parameter variable-blank chart

Clever_Anjos — Wed, 20 Jul 2016 12:04:27 GMT

Please put this into a textbox and tell us what it returns

=$(eDeparturesPerformed_VarUnit(1))

Re: Parameter variable-blank chart

Clever_Anjos — Wed, 20 Jul 2016 12:04:42 GMT

And this too

=eDeparturesPerformed_VarUnit

Re: Parameter variable-blank chart

Wed, 20 Jul 2016 12:23:56 GMT

both are returning hyphen symbol

Re: Parameter variable-blank chart

Clever_Anjos — Wed, 20 Jul 2016 12:25:36 GMT

And

Sum([# Departures Performed])

Re: Parameter variable-blank chart

Wed, 20 Jul 2016 12:29:38 GMT

Sum([# Departures Performed]) /$1 is not correct syntax in textbox but I am following same as mentioned in Chapter 10 of guide "Qlikview 11 for Developers"

Re: Parameter variable-blank chart

Clever_Anjos — Wed, 20 Jul 2016 12:31:26 GMT

No, only this Sum([# Departures Performed])

Does this expression returns a value?

Re: Parameter variable-blank chart

Wed, 20 Jul 2016 12:33:30 GMT

yes

Re: Parameter variable-blank chart

Clever_Anjos — Wed, 20 Jul 2016 12:40:19 GMT

I´ve attached a working sample, please check

Re: Parameter variable-blank chart

Wed, 20 Jul 2016 12:44:41 GMT

I cannot open as I do not have licensed version

Re: Parameter variable-blank chart

jyothish8807 — Wed, 20 Jul 2016 12:45:47 GMT

Hi vsharma,

While declaring the variable dont use "=" sign in the beginning and try.

eDeparturesPerformed_VarUnit

Sum([# Departures Performed]) /$1

Then in text box:

=$(eDeparturesPerformed_VarUnit(1))

Regards

Re: Parameter variable-blank chart

Wed, 20 Jul 2016 12:47:01 GMT

try to define variable as below:

eDeparturesPerformed_VarUnit= Sum([# Departures Performed]) /num($1)

Re: Parameter variable-blank chart

Digvijay_Singh — Wed, 20 Jul 2016 12:53:04 GMT

See the working copy here -

Dimension - Carrier Group

Expression

$(eDeparturesPerformed_VarUnit(1))

Definition -

Sum([# Departures Performed]) / $1

Re: Parameter variable-blank chart

Clever_Anjos — Wed, 20 Jul 2016 12:58:33 GMT

use this Sum([# Departures Performed]) /$1 as your variable, without "="