topic Re: Bucket wise trending in QlikView

Bucket wise trending

sridhar_sigired — Tue, 12 Jan 2016 11:55:46 GMT

Hello,

I have day wise call length (in seconds) data with different call types.

I need to show day wise average call length for call type wise, which is available in attachment.

However i need to show same trend information bucket wise. Buckets are created in sample QVW. The requirements looks like in requirement.png snapshot.

Since line chart will accept only two dimension, i am confused how to include bucket information. Any suggestions pls?

Thanks alot.

Sridhar. S

Re: Bucket wise trending

Anonymous — Tue, 12 Jan 2016 12:18:33 GMT

Nothing in your attachment, also what exactly you want??

what issue you are facing?

You want to show Bucket wise Trend?

Re: Bucket wise trending

Anonymous — Tue, 12 Jan 2016 12:20:01 GMT

check these as well?

Buckets

Creating Aging Buckets within QlikView

Creating Buckets in the Load Script

Re: Bucket wise trending

sridhar_sigired — Tue, 12 Jan 2016 12:26:26 GMT

Attached reloaded QVW. Sorry for inconvenience.

There are two charts i need to create.

1. Trend - Average call time in minutes call type wise

2. Trend - Average call time in minutes call type wise in bucket size.

First one is available in QVW and second one how it looks like available in requirement jpg.

Just need a idea how can we show this information. Since date also need to show in dimension, i am confused how i have to show bucket information.

Re: Bucket wise trending

Anonymous — Tue, 12 Jan 2016 12:33:06 GMT

Which one is your Bucket field??

Re: Bucket wise trending

Anonymous — Tue, 12 Jan 2016 12:35:17 GMT

Why not try with Grid Chart??

You can plot Date as X axis and Bucket as Y Axis and then expression for same

Re: Bucket wise trending

sridhar_sigired — Tue, 12 Jan 2016 12:47:30 GMT

Cal_Duration_Range is my bucket field. Pls see script once. Grid chart i cannot show trend na.

Re: Bucket wise trending

settu_periasamy — Tue, 12 Jan 2016 12:57:07 GMT

May be like this?

Re: Bucket wise trending

sridhar_sigired — Tue, 12 Jan 2016 13:03:12 GMT

Look slimier, can you post your QVW file. Thanks.

Re: Bucket wise trending

Anonymous — Tue, 12 Jan 2016 13:13:23 GMT

Okay, I would suggest Keep your dimensions fields as it is...

Write 5 expression for this bucket in expression tab instead of your current expression...

Like :

For 5 : sum({<Call_Duration_Range={'5'}>} duration)

similarly for other values

Re: Bucket wise trending

settu_periasamy — Tue, 12 Jan 2016 13:15:25 GMT

Just a Calculated Dimension..

=CALL_TYPE&'-'&Cal_Duration_Range

Re: Bucket wise trending

Anonymous — Tue, 12 Jan 2016 13:20:30 GMT

Check the attachment...

Re: Bucket wise trending

sridhar_sigired — Tue, 12 Jan 2016 13:22:08 GMT

Seems like we can apply this, and need to enter Call type also in Set expression.

But in future if new call types will be added then it will create problem.

Anyway thanks for idea.

Re: Bucket wise trending

sridhar_sigired — Tue, 12 Jan 2016 13:30:15 GMT

Thank you Balaraj for your time.