Set Analysis Help

[#1]

Hi Community,

refer below sample data -:

Segment                                   Company code       No of Account

ABC                                           A                              20

ABC                                           B                              50

ABC                                           C                              0

ABC                                           D                              30

ABC                                           E                              0

ABC                                           F                              10

ABC                                           G                              0

ABC                                           H                              30

ABC                                           I                                0

ABC                                           K                              10

ABC                                           L                               20

ABC                                           M                              40

--------------------------------------------------------------------------------------------------                                 

                                                  Total                         210

I have Segment ABC and this ABC Segment have multiple Company Code like A,B,........,M

Each Company Code have multiple account that means Company Code A having diffrent number of 20 Accounts.

So i want number of bucketing according to there account number count.

e.g.

Sement  | (Bucketing) Zero (0) |  Less than or  equal to ( 10 ) But greater than Zero |  11-20  | 21-30 | 31-40 | 41-50   |  Total
             |                               |                                                                          |            |          |          |            |     

ABC      |           4                   |        2                                                                |     2     |   2     |    1     |    1      |  12

Above table is my expecated answer for that which table chart i have to use?

and i have one more doubt in my mind is it possible in qlikview to count unmapped that means in above example Zero no of accounts?

Thanks in Advance.

Regards,

Ishwar

[#2]

Hi,

Anbu

I have  calculted Account number field using Set analysis because when i calculated this field using set analysis then i got account number with respect to there comapany code.

I have used pivot table Dimention as Segment and Expression as  Account nuber using set analysis.

So how i use this field for buket calculation or for my expected output?

[#3]

Hi

Ashwani,

I have also refre your QVW.

i want bucket on dashbord Chat table because I have  calculted Account number field using Set analysis when i calculated this field using set analysis then i got account number with respect to there comapany code.

[anbu1984]

Can you post sample input and expression for Account Number?

[#5]

Hi Anbu,

- Refer below expression I have written for Account number -

COUNT({< ZERO_FLAG_TEST={'TEST'},ACCOUNT_NO=E({< PROMO_CODE ={"ABC"}>}),PROGRAM_UPDATE = {"SS"}>}ACCOUNT_NO)

- Also refer below screen shot

- I have calculated Account number againest the ECB segment, Now i want to bucketing all account number with respective to there condition that i have mention in my starting post.

- I also want (Zero bucketing) is separate and (greter than zero and less than 10 bucketing) is separate.