topic Re: User defined field within expression in QlikView

User defined field within expression

mattphillip — Wed, 25 Nov 2020 16:16:04 GMT

Hoping someone can help. I have an expression for calculating percentages within a table where users can define the visible fields:

=count({$<[Retained]={'Yes'}>}[Student ID])/count(TOTAL <GetFieldSelections(Fields)> [Student ID])

The getfieldselections statement is meant to allow users to specify what the context of the calculated percentage e.g. by programme, gender, session etc. However when I try this, the calculation is blank.

Does anyone know where I might be going wrong?

Appreciated.

Matt

Re: User defined field within expression

sunny_talwar — Thu, 12 Oct 2017 12:48:45 GMT

May be try this

=Count({$<[Retained]={'Yes'}>}[Student ID])/Count(TOTAL <$(='[' & GetFieldSelections(Fields) & ']')> [Student ID])

Re: User defined field within expression

mattphillip — Thu, 12 Oct 2017 12:54:44 GMT

Thanks Sunny that does work! One question though, is there a way for it to accept multiple selections? E.g. selecting session and gender to display a percentage which adds up to 100% for each session.

Thanks,

Re: User defined field within expression

sunny_talwar — Thu, 12 Oct 2017 12:57:22 GMT

May be try this

=Count({$<[Retained]={'Yes'}>}[Student ID])/Count(TOTAL <$(='[' & GetFieldSelections(Fields, '], [') & ']')> [Student ID])

Re: User defined field within expression

mattphillip — Thu, 12 Oct 2017 13:00:08 GMT

Brilliant thanks!

Re: User defined field within expression

mattphillip — Tue, 17 Oct 2017 13:34:03 GMT

Hi Sunny,

Hoping you might be able to help with a quick question, I'm trying to add in an additional set analysis criteria (specifying a particular session) to the above expression but it's throwing up errors. Any ideas why?

=count({$<[Retained]={'Yes'},[Session]={'2015/16'}>}[Student ID])/count(TOTAL <{$(='[' & GetFieldSelections(Fields, '], [') & ']'),[Session]={'2015/16'}>}[Student ID])

Many thanks,

Matt

Re: User defined field within expression

sunny_talwar — Tue, 17 Oct 2017 13:37:01 GMT

Because what I added was not set analysis, it was field name used by TOTAL qualifier... try this

=Count({$<[Retained]={'Yes'}, [Session]={'2015/16'}>} [Student ID])/Count({<[Session]={'2015/16'}>} TOTAL <$(='[' & GetFieldSelections(Fields, '], [') & ']')> [Student ID])

Re: User defined field within expression

mattphillip — Tue, 17 Oct 2017 13:38:39 GMT

Its been a long day...thanks Sunny, much appreciated!