Grouping Data and Counting.

[#1]

I am new to Qlikview. I am trying to accomplish the following.

I have about 25,000 users and their monthly spending. I have grouped then as following

I have created a List box with Month.I have one char which displays Month wise total number of usesr who uses credit card.

For the above char I used the following: Dimension: YYMONTH

Experession Count (DISTINCT USER_ID)

Now I want to group them

I have a field called CHARGED_AMOUNT

Count number of users who spent <1000

Count number of Users who spent 1000-4999

Count number of users who spent 5000-9999

Count number of users who spent 10000-19999

Count number of users who spent >20000

How do I count?

Thank you

[#2]

Hi,

Try the following expression(s):

Count ({<Amount={'<1000'}>} DISTINCT USER_ID)

Count ({<Amount={'>=1000<5000'}>} DISTINCT USER_ID) etc

[#3]

HI cchhatralia

Thanks for the reply. I did as follows

DIMENSION: CREDIT_CARD_MODEL (we have only one credit card model

Experession: Count ({<CHARGED_AMOUNT={'<1000'}>} USER_ID)

But the outcome is slightly different. It calculates number of times the user spend less then 1000. Since I have 5 months data and the user spent every month less then 1000 for the past 5 months it calculates 5.

See the image

I can add additional dimension. but looks like the result I am expecting is different

I want First coulum Total number of User who spent < 1000. Remember I have a list box which contains months. We have 5 months of data. So the user may spent each month some amount. I can select YYMM from my listbox which will narrowdown on month basis.

[#4]

are you able to post a sample doc?

[#5]

Sure. Thanks I have attached a dummy data file here

[kumarnatarajan]

Hi,

You cat able to use Class() function

Ex : http://community.qlik.com/thread/65352

Else

You cat able to use Dual() function and if() Condition

EX : http://community.qlik.com/thread/4328

Else you want more details share Sample. I can help you

[#7 · Accepted solution]

See the attached.  Is this what you are after?

(The bands are respective of what you have above.)

[#8]

Thank you cchhatralia. Great Nice of you helping me..