topic Re: Help with expression in QlikView

Help with expression

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

I am using the following expression to create a table showing enrolments by region and year PLUS a Projection for 2016-17

Count({$<region=>} enrolments)
& Projection

However, the table does not show a SUM total for the Projection and when I tried to add a SUM element to the expression it also changed the values for the number of actual enrolments in a Year.

I used set analysis because I wanted the table to show all the regions regardless of a user selecting a region. Instead, I have set up the table to highlight the selected region like below -

But the Projections for the regions not selected have disappeared.

Can someone help me with the expression?

Thanks

Greg

Re: Help with expression

tresB — Tue, 24 Jan 2017 08:57:51 GMT

Is it 'region' or 'Region' ? Field name is case sensitive here. Count({$<Region=>} enrolments)

Re: Help with expression

Anonymous — Tue, 24 Jan 2017 08:58:15 GMT

Try using

sum(Projections)

Re: Help with expression

Anonymous — Tue, 24 Jan 2017 09:00:52 GMT

Or sum({<Region=>}[Projection]) to ignore the region selection

Re: Help with expression

Anonymous — Tue, 24 Jan 2017 09:01:04 GMT

Hi Greg,

Try RangeSum(Count({<region=>}enrolments),Sum(Projection))

Regards!!