topic Re: Count Need in Text Box in QlikView

Count Need in Text Box

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

Hi Using below data I need count of ID which are having >5000 by Monthwise in text box using aggregation functions But not >sales.

LOAD * INLINE [

ID, Month, Sales

1, Jan, 2347

2, Feb, 3274

3, Mar, 388

4, Jan, 32476

5, Feb, 37781

6, Mar, 53782

7, Jan, 23857

8, Feb, 326

9, Mar, 5673

10, Jan, 46811

11, Feb, 9621

12, Mar, 74635

13, Jan, 83527

14, Feb, 62729

15, Mar, 39

16, Jan, 255

17, Feb, 342

18, Mar, 66739

];

Re: Count Need in Text Box

subbareddykm — Wed, 28 Dec 2016 16:12:37 GMT

OutPut Is :

Jan	4
Feb	3
Mar	4

Re: Count Need in Text Box

sunny_talwar — Wed, 28 Dec 2016 16:38:54 GMT

May be this as your expression

Count(DISTINCT {<ID = {"=Sum(Sales) > 5000"}>} ID)

Re: Count Need in Text Box

sunny_talwar — Wed, 28 Dec 2016 16:40:40 GMT

Sample attached

Re: Count Need in Text Box

subbareddykm — Wed, 28 Dec 2016 17:06:51 GMT

Thankq sunny For ur reply,

But In my scenario , where i have three exp

If(

(Sum({<Month1={'Jan'}>}Sales1)+

Sum({<Month2={'Jan'}>}Sales2)+

Sum({<Month3={'Jan'}>}Sales3)) >5000,Count(Distinct ID)

This is not Worling 😞

What should i write here in my case

Re: Count Need in Text Box

sunny_talwar — Wed, 28 Dec 2016 17:07:52 GMT

What is Month1, Month2, Month3 here?

Re: Count Need in Text Box

subbareddykm — Wed, 28 Dec 2016 17:21:54 GMT

Each Amouunt is having diff months

actually i have date date fields instead of that i m showing Month

Re: Count Need in Text Box

sunny_talwar — Wed, 28 Dec 2016 17:29:28 GMT

It would be better if you provide data which is more aligned to your actual data

Re: Count Need in Text Box

subbareddykm — Thu, 29 Dec 2016 16:16:18 GMT

Sunny i have one more query

If i want take some range from 5000 to 50000 for below expression,How to write this :

Count(DISTINCT {<ID = {"=Sum(Sales) > 5000"}>} ID)

Can any one help me on this

Re: Count Need in Text Box

sunny_talwar — Thu, 29 Dec 2016 16:26:29 GMT

May be this

Count(DISTINCT {<ID = {"=Sum(Sales) > 5000 and Sum(Sales) < 50000"}>} ID)