topic Re: Pivot Table total issue. in QlikView

Pivot Table total issue.

infosense_devel — Tue, 06 Mar 2018 16:09:15 GMT

Hello All,

i have created one pivot table with hide/show functionality for its dimension and expression columns.

as per below.

Now we have requirement where we need to have sum for each expression, if i take example of above image, there should be total of actual and budget. only simple total same like we are usually having in simple table.

Any idea how to achieve it?

Re: Pivot Table total issue.

YoussefBelloum — Tue, 06 Mar 2018 16:21:08 GMT

Hi,

did you try to check the "Sub totals" on the dimensions ?

Re: Pivot Table total issue.

infosense_devel — Tue, 06 Mar 2018 16:23:58 GMT

thanks for your reply.

but i dont know what dimensions will user select from that dimension list box.

Re: Pivot Table total issue.

YoussefBelloum — Tue, 06 Mar 2018 16:35:03 GMT

No problem, it is called ad-hoc table, it is on demand.

so on the table, you should have all your dimensions already used on the dimension tab.

and for the display, it is dynamic with something like this:

=SubStringCount('|' & Concat(distinct ad_hoc_dim_field, '|') & '|', '|Model_dimension_field|')

so you can activate all the sub total for all the dimensions.

Re: Pivot Table total issue.

infosense_devel — Tue, 06 Mar 2018 16:37:39 GMT

but here my requirement is to have only one total you can call grand total.

for each expression column i need one total.

Re: Pivot Table total issue.

YoussefBelloum — Tue, 06 Mar 2018 16:43:44 GMT

Yes, for each measure, just under the expression label, you will have a TOTAL line,

That's what you're trying to do ?

Re: Pivot Table total issue.

infosense_devel — Tue, 06 Mar 2018 16:45:07 GMT

Yes

Re: Pivot Table total issue.

YoussefBelloum — Tue, 06 Mar 2018 16:47:02 GMT

so the only option you have is the one I mentioned above.

Is it clear ?

Re: Pivot Table total issue.

infosense_devel — Tue, 06 Mar 2018 17:03:32 GMT

yes in that case if i will select three column from dimension i will have three same amount as total.

means three line for total with same value.

Re: Pivot Table total issue.

YoussefBelloum — Tue, 06 Mar 2018 17:10:19 GMT

you will have this with the selections made on the first screen shot (no matter how many dimension you will select, it depends only on the number of measures)