topic Re: Pivot table total header names in QlikView

Pivot table total header names

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

Hi All,

I have an issue with pivot table total headers.

Currently i have a povit table with 2 dimension and 3 expression,

I have a requirement where i should drag second dimension into vertical as shown below .

Hear the problem is Total for each year should show for particular year.For example

year 2018 total should be :2018 total

Expected output should be like below

Here are the Sample qvw and expected output files.

stalwar1‌

stevedark‌

theresaa‌

Re: Pivot table total header names

sunny_talwar — Sun, 25 Feb 2018 11:39:57 GMT

Unfortunately, I don't think that this would be possible

Re: Pivot table total header names

passionate — Sun, 25 Feb 2018 11:47:43 GMT

Hi Hari,

PFA

Cheers,

Pankaj

Re: Pivot table total header names

sunny_talwar — Sun, 25 Feb 2018 11:49:46 GMT

But this is showing the same year for both sub-totals... I think the OP wants this

Re: Pivot table total header names

passionate — Sun, 25 Feb 2018 12:00:21 GMT

yes, you are correct

Re: Pivot table total header names

sunny_talwar — Sun, 25 Feb 2018 12:14:39 GMT

Check to see if the attached approach works for you

Re: Pivot table total header names

Anil_Babu_Samineni — Sun, 25 Feb 2018 12:51:30 GMT

Only may be missed - Suppress for that Match() condition which second dim?

Re: Pivot table total header names

hari8088 — Sun, 25 Feb 2018 13:27:14 GMT

Hi Sunny,

The approach is not working for me.In my case i have to give 3 expressions.Since i have different expressions like annual calculation for max year as well.

In pivot out put total is showing 2 times but it should not.

In case the output does not possible at least if we can get only single total.That would be helpful.

Thanks..

Re: Pivot table total header names

hari8088 — Sun, 25 Feb 2018 13:29:38 GMT

Hi Pankaj,

Thanks for your replay.......

The condition is not working in this case.

Re: Pivot table total header names

sunny_talwar — Sun, 25 Feb 2018 17:17:28 GMT

Not sure what you mean?

Re: Pivot table total header names

sunny_talwar — Sun, 25 Feb 2018 17:18:17 GMT

Unless you share what you have, it would be difficult to know what might be the issue.... or may be someone else have better ideas for you

Re: Pivot table total header names

pablolabbe — Sun, 25 Feb 2018 23:52:17 GMT

When applicable please mark the appropriate replies as CORRECT. This will help community members and Qlik Employees know which discussions have already been addressed and have a possible known solution. Please mark threads as HELPFUL if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem. You can mark multiple threads as HELPFUL if you feel additional info is useful to others

Re: Pivot table total header names

hari8088 — Mon, 26 Feb 2018 01:52:08 GMT

Sunny,

See the screenshot as we see currently i am getting Total for both the dimensions:

Actual output i am getting:

Expected output:

Re: Pivot table total header names

sunny_talwar — Mon, 26 Feb 2018 02:23:07 GMT

But you initially mentioned that you wanted the year? I am somewhat confused

Re: Pivot table total header names

hari8088 — Mon, 26 Feb 2018 03:58:35 GMT

‌Sorry for the confusion

That was the main requirement but if you see this one also one off the issue in the headers.

Re: Pivot table total header names

passionate — Tue, 27 Feb 2018 15:06:26 GMT

For total coming twice you can use Year as Dimension.

PFA

Cheers,

Pankaj