topic plzz help me its aurgent in QlikView

plzz help me its aurgent

Mon, 11 May 2015 16:27:27 GMT

= plz help me

i want a line chart which shows the flow of calls by using Buckets .like

0-5,6-10,11-15,16-20,21-25,26-30,31-35,36-40, up to 50 above 50 -100 bucket

above count get by count(ticket_id) dimension is (call log_date)

please Kindley View Below Qvd

Re: plzz help me its aurgent

Anonymous — Mon, 11 May 2015 17:46:45 GMT

Take a look at the class() function. you can use it for the buckets from 0 to 50, and conditionally the other buckets. Your data is not representative enough, every day falls in 0-5.

Re: plzz help me its aurgent

MarcoWedel — Mon, 11 May 2015 17:49:28 GMT

Hi,

maybe this helps:

Custom Filter(unusual range)

Regards

Marco

Re: plzz help me its aurgent

Mon, 11 May 2015 18:08:03 GMT

thanks for your response Marco.

should i concert my dates to numerical values .iam very confused plz guide me with steps it Would be very thank full to u plz.

Re: plzz help me its aurgent

MarcoWedel — Tue, 12 May 2015 00:19:11 GMT

Are your buckets numbers of tickets per day?

Then please provide sample data with enough tickets per day and your expected result to demonstrate

regards

Marco