Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

Expandable Header in Pivot Table & total sales by customer in percentage

Hi All,

I am new to QlikView and Still learning and I have two questions. I have attached the QVW file for your reference.

The Data Model contains Customer name, Order ID and Order Status as below in one single table

Data Model.png

(Question 1) How to create an expandable column like following:

I have created a below Pivot Table.

Desired Picot.png

And I want this table to expand look like below table Only When I click on the header 'Order received'.

Pivot in Total Numbers.png


(Question 2) How to get total sales by Customer in (%) Percentage?

Which expression should I write to show the total sales volume in (%) by each customer out of 100%.

I wrote the expression  =num(count(OrderId),'0%') but it is giving below.

Pivot in Percentage.png

Thank you.

Tags (2)
1 Solution

Accepted Solutions

Re: Expandable Header in Pivot Table & total sales by customer in percentage

HI,

Have a look at the attached application.

Regards,

Kaushik Solanki

5 Replies

Re: Expandable Header in Pivot Table & total sales by customer in percentage

HI,

Have a look at the attached application.

Regards,

Kaushik Solanki

Re: Expandable Header in Pivot Table & total sales by customer in percentage

See if the attached helps:

Click on Order Received to show the two extra columns (Transparent text box on top of Order Received)

Capture.PNG

Not applicable

Re: Expandable Header in Pivot Table & total sales by customer in percentage

Thank you Kaushik. It Worked

Not applicable

Re: Expandable Header in Pivot Table & total sales by customer in percentage

Thank you Sunny, I never thought of putting a transparent text object on the header but yes, it is doing as expected so thanks for the idea.

Re: Expandable Header in Pivot Table & total sales by customer in percentage

Glad you like the idea

Community Browser