topic Re: Total presentation in Pivot Table in QlikView

Total presentation in Pivot Table

tyagishaila — Wed, 15 Jul 2015 08:13:56 GMT

Hi All,

I need to show total in pivot table, as in screenshot.

i.e. Total based on LFL column must placed 1 after another in a single column.

How can I achieve this, please help me out.

Thanks,

Re: Total presentation in Pivot Table

Gysbert_Wassenaar — Wed, 15 Jul 2015 08:23:21 GMT

That can't be done in a pivot table. Your screenshot also doesn't show a pivot table. Qlikview is not a spreadsheet application. Insisting on using it as one will be a very frustrating experience.

Re: Total presentation in Pivot Table

MK_QSL — Wed, 15 Jul 2015 08:24:58 GMT

How IntervalMatch Solved My Profit and Loss Dilemma

You need to create report something like this...

Re: Total presentation in Pivot Table

tyagishaila — Wed, 15 Jul 2015 08:30:41 GMT

I attached excel sheet that created by our department. We are creating this report by qlikview,

that department need, Total must show in the same way.

I did it by create new dimension value like Total-NCR with where condition and concatenate it with field LFL.

Total is showing okay, but performance is getting down, may be because of concatenate column values for Total increase the size of data.

Re: Total presentation in Pivot Table

prashantbaste — Wed, 15 Jul 2015 09:58:29 GMT

As per my understandings after looking at your que & attached screenshot what I can suggest is this can be achieved by making some changes in your model -

Map store code (or other fields as per requirements) with your desired Total field names & add those in chart can help you to show Total field.

Hope this will be helpful for you.

Regards,

Prashant P Baste