Using pre-calculated expression/variable in set analysis output

kgarvind — Wed, 11 May 2016 11:36:46 GMT

I have been using a lot of variable derived out of expressions for charts. no problem, they are working fine. Now i am enhancing some charts which require filtered selection for calculation - hence using set analysis.

eg: e_Utilization (variable) - reference =

$(e_Production_Uptime_Minutes) / $(e_Production_Available_Minutes)

e_Production_Uptime_Mins = (sum([Uptime Minutes])-sum({<[Event Utilization Subcategory] = {'Planned Downtime'}>} [Uptime Minutes]))

e_Production_Available_Mins = (sum([Available Minutes]) - sum({<[Event Utilization Subcategory] = {'Planned Downtime'}>} [Available Minutes]))

Now i use them in my set analysis

SUM({1<

[Line Name] = {'LINE 02'},

CalendarDate = {'$(v_RptDate)'}

$(e_Utilization)

)

Returns nothing.

Anything i am missing / doing wrong.

Appreciate any suggestions/help/comments and your time.

Thanks

topic Using pre-calculated expression/variable in set analysis output in QlikView

Using pre-calculated expression/variable in set analysis output