topic Re: How to create this table in Qlikview? in QlikView

How to create this table in Qlikview?

Wed, 25 Nov 2020 16:16:04 GMT

Hi All,

Basically, I want to show the total volume of calls for the toll free number, within that total volume, how many are hang ups, self-service and get-into-queue calls. Then I want to show how many calls are answered, abandoned or transfer to another place in that get-into-queue calls per business unit. I also want to add intent as another bucket under business unit (plus sign as in pivot table).

How do I create this table or something similar? Or is there a better way to show to data?

Thank you for your inputs.

Re: How to create this table in Qlikview?

sunny_talwar — Sat, 10 Sep 2016 00:14:17 GMT

This?

Re: How to create this table in Qlikview?

Mon, 12 Sep 2016 12:44:36 GMT

Yes Sunny, and also the plus signs on Sales, Service and Other indicate that it can be expanded to Intent.

For example:

Sale -

Getting Quote

Service -

Cancel Policy

Renewal

Other -

Question about Discount

Re: How to create this table in Qlikview?

sunny_talwar — Mon, 12 Sep 2016 15:51:46 GMT

Would you be able to provide a sample to look at?

Re: How to create this table in Qlikview?

Mon, 12 Sep 2016 16:13:23 GMT

Hi Sunny,

I have attached a sample in Excel. You can see sample data in the data tab, final tab is what I want which I manually format from pivot sheet.

Thank you for your help.