topic count expression i need in dimension but doesnt work in QlikView

count expression i need in dimension but doesnt work

qliklizzy — Sat, 16 Nov 2024 02:32:39 GMT

I have this as an expression but because of it being a pivot its repeated in each group so I want it in the dimension instead to show alongside the month and day - is this possible as if I use it in dimension I get error. I tried using total but that just repeated the figure across the dates

=num(Count({<EdReadyKPI = {'Under'}>}EdReadyKPI)/Count(EdReadyKPI)*100, '#,#0%' )

thanks

Liz

Re: count expression i need in dimension but doesnt work

rubenmarin — Sun, 08 Sep 2019 21:32:24 GMT

Hi, try using aggr:

Aggr(num(Count({<EdReadyKPI = {'Under'}>}EdReadyKPI)/Count(EdReadyKPI)*100, '#,#0%' ), [Dim1, Dim2,...])

Change [Dim1, Dim2,...] for the current dimensions used in table.

Re: count expression i need in dimension but doesnt work

qliklizzy — Mon, 09 Sep 2019 08:57:46 GMT

Thanks worked a treat!!!😉