Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

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

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

2 Replies
Not applicable

Re: Pivot table Quz

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.


Re: Pivot table Quz

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.

Community Browser