topic Re: Total 3 Line in the PivotTable in QlikView

Total 3 Line in the PivotTable

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

I have a table with the Dynamic billing performed during every day of the month.

At the end of the table I have the total accomplished using the dimensionality and SecondaryDimensionality function.

The data are 100% correct.

What happens is that I have 3 lines in total, Held, Meta and efficiency and only Held in data from day to day as print Imagem1.

There is like leaving the entire table with only one line and Total with 3 lines?

Re: Total 3 Line in the PivotTable

MK9885 — Mon, 19 Sep 2016 19:04:54 GMT

Yes,

Properties>Presentation Tab>Dimensions and Expressions>Check 'Show Partial Sums' for only first dimension and uncheck 'Show Partial Sum for all others.

Note: Just select for first dimension and you'll get only one total for that particular dimensions you've checked and rest of the dimensions will not show totals.

Re: Total 3 Line in the PivotTable

Anonymous — Mon, 19 Sep 2016 19:19:38 GMT

It would not be the request or need

Re: Total 3 Line in the PivotTable

MK9885 — Mon, 19 Sep 2016 20:21:47 GMT

sorry, I did not understand your question?

Re: Total 3 Line in the PivotTable

Anonymous — Tue, 20 Sep 2016 10:41:11 GMT

You can check the attached .docx ? there put a better explanation .

Re: Total 3 Line in the PivotTable

Anonymous — Fri, 23 Sep 2016 11:58:24 GMT

Does anyone have any suggestions?

Re: Total 3 Line in the PivotTable

MK9885 — Fri, 23 Sep 2016 15:29:19 GMT

I still do not understand what you want? I've checked your attachment doc and I'm sorry to say it doesn't explains correctly.

Paste screenshots here...
1.What you've

2.What you need

3. What problem you facing while doing it.

Thanks.

Re: Total 3 Line in the PivotTable

MK9885 — Fri, 23 Sep 2016 16:27:44 GMT

Maybe stalwar1‌ can help you?

Re: Total 3 Line in the PivotTable

sunny_talwar — Fri, 23 Sep 2016 17:07:27 GMT

Best I am able to offer right now is this

One shows subtotals for the three at the bottom and other one doesn't show subtotals at all. We can further play around with this, but wanted to know if this is even worth effort . If this isn't looking useful, then may be someone else can offer help. Also, if someone else want to take it further, I am attaching the qvw file to look at.

Best,

Sunny

Re: Total 3 Line in the PivotTable

sunny_talwar — Fri, 23 Sep 2016 17:42:43 GMT

Okay, this seems like taking it all the way now

=Pick(Dim, Sum(Value), If(Dimensionality() = 1, Sum(Value)), If(Dimensionality() = 1, 13627), If(Dimensionality() = 1, Num(Sum(Value)/13627, '##.00%')))