Discussion Board for collaboration on QlikView Scripting.
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
I have created a below Pivot Table.
And I want this table to expand look like below table Only When I click on the header 'Order received'.
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.
Go to Solution.
Have a look at the attached application.
See if the attached helps:
Click on Order Received to show the two extra columns (Transparent text box on top of Order Received)
Thank you Kaushik. It Worked
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.
Glad you like the idea