Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Make your voice heard! Participate in the 2020 Wisdom of Crowds® Survey. BEGIN SURVEY
Not applicable

How to create this table in Qlikview?

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?

Example.png

Thank you for your inputs.

4 Replies
Highlighted

Re: How to create this table in Qlikview?

This?

Capture.PNG

Highlighted
Not applicable

Re: How to create this table in Qlikview?

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

       Subscribe

Service -

       Cancel Policy

       Renewal

Other -

       Question about Discount

Highlighted

Re: How to create this table in Qlikview?

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

Highlighted
Not applicable

Re: How to create this table in Qlikview?

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.