Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
kgarvind
Partner - Contributor
Partner - Contributor

Using pre-calculated expression/variable in set analysis output

Hi

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

0 Replies