Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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
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..