Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
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
sunny_talwar

This?

Capture.PNG

Not applicable
Author

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

sunny_talwar

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

Not applicable
Author

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.