Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Dimension:Class(NoofAccount,10)
Expression: Count(NoofAccount)
='Count of Unmapped :' & Count({<NoofAccount={0}>}NoofAccount)
Hi Anbu,
Thank u for your quik reply.
Can you give your solution with QVW ?
Are you not able to see QVW attached in previous post?
I am attaching QVW again
like this?
pivot table
dimension Segment
=replace(Class([No of Account],10), '<= x < ', '-')
expression Count([No of Account])
Hi
Anbu,
still i didn't got your QVW please again share your QVW with me for reference pupose.
Hi Massimo,
From your image i think you may be you on right track but can you share with me your QVW for reference purpose?
Now I got your QVW File.
Thanks.
Attaching again
PFA
it can be done in multiple ways.
Class function is good to use.
You can also use If condition for Bucketing. QVW attached.
