topic Get the count of [Week No] only for maximum [Week No] using Expression formula. in QlikView

Get the count of [Week No] only for maximum [Week No] using Expression formula.

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

Hi,
I am very new to qlikview but am good excel functions. Here I want to get the

1) count of [Week No] only for maximum [Week No]!

example

- the maximum number is 18 and the count is 3. if its 17 the count is 2. for 16 also its 2.

2) Also the total count of G,R,Y for a particular maximum week number.

- For example 18,G is 3,R is 0 and Y is 0.

17 - G is 1,R is 1 ,Y is 0

16 - G is 0,R is 1 ,Y is 1

I need to use this expression formula of a Text Box.

Thanks.

sunny_talwar — Thu, 11 May 2017 15:40:35 GMT

May be this

1) Count({<[Week No] = {"$(=Max([Week No]))"}>} [Week No])

2) Same expression as above

Count({<[Week No] = {"$(=Max([Week No]))"}>} [Week No])

but use Activity A as your dimension

praveenpurush6 — Fri, 12 May 2017 05:37:54 GMT

Hi Sunny,

Thanks a ton. First formula worked fine...The Second one I made changes referring the other threads and arrived on the below.

=Count({<[Week no] = {"$(=Max([Week no]))"},[Activity A]={'R'}>} [Activity A])

=Count({<[Week no] = {"$(=Max([Week no]))"},[Activity A]={'G'}>} [Activity A])

=Count({<[Week no] = {"$(=Max([Week no]))"},[Activity A]={'Y'}>} [Activity A])

Praveen..