topic Re: Variable as expression in Chart in QlikView

Variable as expression in Chart

Anonymous — Thu, 16 Oct 2014 08:23:29 GMT

Dear Experts,

I am storing a values in Variable says Total Sale and now I have to use this variable as expression in Bar Chart as expression across a Dimension say Zone wise...

But when I am using in Bar Chart taking dimension Zone and expression as VTotalSales...

It is showing me same figure across all zones...

Pls suggest, why it is?

Regards,

Balraj

Re: Variable as expression in Chart

arulsettu — Thu, 16 Oct 2014 08:36:15 GMT

check your variable

and expression should be $(VTotalSales)

Re: Variable as expression in Chart

jonathandienst — Thu, 16 Oct 2014 08:38:49 GMT

Of your expression is Sum(Total Sales), then you are telling QV to ignore the chart dimensions, so it will be the same for all dimension values

HTH

Jonathan

Re: Variable as expression in Chart

Anonymous — Thu, 16 Oct 2014 08:43:52 GMT

Jonathan,

Is it solvable??

Re: Variable as expression in Chart

SunilChauhan — Thu, 16 Oct 2014 08:44:18 GMT

in variable expression itselef write

aggr(Sum(Total Sales),Zone )

or simply use sum(Sales) as variable expression