Qlik Community

QlikView Publisher

Discussion Board for collaboration on QlikView Publisher.

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

Pivot table Sub Totals help me please-

Hi All,

In my pivot table i have three columns,

Countrystatecity
AA1A11
AA1A12
Total
AA2A21
AA2A22
AA2A23
Total
BB1B11
BB1B12
Total
BB2B21
Total
BB3B31
BB3B32
Total
Total
Total

In the above example, i am hiding the first two columns as per my requirement by using a simple VB Script, after hiding I wanted to show the sub totals with the names not as 'total' like ... after A12 instead of Tatal i need to show A1, then after A23 i want to show A2 and so on. Please help me to achieve this. I am new to qlikview.

Thank you all for your help in advance.

Community Browser