topic Selectable Expressions for Charts in QlikView

Selectable Expressions for Charts

Anonymous — Wed, 04 Oct 2017 12:59:30 GMT

Hello all.

I am working on a dashboard where I want the user to be able to select which expression to display on the charts.

This was working for me but abruptly stopped working and I can't determine why.

What I have is an inline LOAD with the metric name, dimensions and expressions to use.

I have a list box where the user can select the metric they wish to display. I have three charts (2 bar charts and one pivot table) that have the Expression definition set to $(=Expression).

As I said this was working but has stopped. Any help troubleshooting is appreciated.

Here's the LOAD statement.

LOAD * INLINE

["Metric", Dimension1, Dimension2, Expression

"Utility Pct By Wgt", Wgt, Hrs "=Avg(utilPctGrWgt)"

"Utility Pct By Hrs", Wgt, Hrs "=sum({<dispInd = {1}>} DispHours)/Sum(TotalHours)"];

Thank you,

Nate

Re: Selectable Expressions for Charts

prat1507 — Wed, 04 Oct 2017 15:01:49 GMT

Use

LOAD * INLINE

["Metric", Dimension1, Dimension2, Expression

"Utility Pct By Wgt", Wgt, Hrs, "=Avg(utilPctGrWgt)"

"Utility Pct By Hrs", Wgt, Hrs, "=sum({<dispInd = {1}>} DispHours)/Sum(TotalHours)"];

You missed out on "," after Hrs.

Regards

Pratyush

Re: Selectable Expressions for Charts

Anonymous — Wed, 04 Oct 2017 18:32:21 GMT

Thank you Pratyush!

That was what I was missing. I looked and it so many times I never noticed the missing comma.

Thanks again,

Nate