Skip to main content

Qlik

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Not applicable
‎2014-07-28 03:10 AM

Pivot table Quz

Is it possible to display the value of dimension in case selecting show partial sum in case of Pivot table

Ex:- Business have Retail,F&B, Lounge.My requirement is to display total label as Retail  total ,F&B total,Lounge total

258 Views
0 Likes
2 Replies
Not applicable
‎2014-07-28 11:14 AM
Author

Hi Shwetha, I believe Custom Name of Partial Sums is not doable directly with custom expression. There is one indirect way to do with "Dent" option. Please find the attached qvw for reference.

Otherwise, Add the Rows 'Retail Total' to the filed and customize your expression with Dimensionality function. This little bit Tricky on scripting and UI as well.

Comm127298.qvw
137 Views
0 Likes
JonnyPoole
Employee
Employee
‎2014-07-28 01:05 PM

In response to

I like the offerings from QlikView partners  like NPRINTING or CIA  for these sorts of grid displays. (EX: http://www.vizubi.com/nprinting).  The reason is that you can author the grid / pivot tables directly in Excel using the qlikview QVW and data as the source.  Excel has all the features that Qlik doesn't to customize a pivot table. But you can still generate the pivot table on demand from the QlikView dashboard. good luck.

137 Views
0 Likes