topic Re: Issue with Variable in Set Analysis in QlikView

Issue with Variable in Set Analysis

Thu, 27 Oct 2016 15:46:51 GMT

Hi,

I have the below variable defined:

DY= $[Year] (current selection of the Year)

Set Analysis:

Sum({$< [DIVERSITY DEFINITION]={'SMALL BUSINESS'}, [DIVERSITY YEAR]={$(DY)}>}[Line Amount])

The outcome seems to not work at all. Any help will be much appreciated.

Thank you!

shraddha_g — Fri, 28 Oct 2016 04:31:41 GMT

Try:

DY= getcurrentfieldselection(Year)

Set Analysis:

Sum({$< [DIVERSITY DEFINITION]={'SMALL BUSINESS'}, [DIVERSITY YEAR]={'$(DY)'}>}[Line Amount])

stabben23 — Fri, 28 Oct 2016 05:54:42 GMT

Hi,

try this without variable.

Sum({$< [DIVERSITY DEFINITION]={'SMALL BUSINESS'}, [DIVERSITY YEAR]={$(=max(Year)) }>}[Line Amount])

sunny_talwar — Fri, 28 Oct 2016 10:43:58 GMT

May be this:

Sum({$< [DIVERSITY DEFINITION]={'SMALL BUSINESS'}, [DIVERSITY YEAR]={$(=DY)}>}[Line Amount])