topic Re: Pivot table Quz in QlikView

Pivot table Quz

Mon, 28 Jul 2014 07:10:25 GMT

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

Re: Pivot table Quz

Mon, 28 Jul 2014 15:14:27 GMT

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

JonnyPoole — Mon, 28 Jul 2014 17:05:47 GMT

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.