Grouped Expressions NOT Working on Pivoted Tables - Page 2 - Qlik Community

christian77 · ‎2014-08-26

Hi Qlikers.

I found that grouped expressions don’t work on pivoted tables.

Does anybody knows why?
Is this a bug?

Can it be fixed?

Is it a workaround?

I’m attaching a sample in order to solve this problem.

Thanks and salutes.

christian77 · ‎2014-08-27

Hi.

Thanks to all for following.

Here is how it could be done. The first one is redundant. The second has a merged header cell. The thing is that when you have pivoted table showing the name of each dimension, but it doesn't show the name of the metric, we have to say the name of the metric in the title bar, in order to know what we have in front. Otherwise, what are we seeing?

Marcus' solution in the 3rd image. It is also redundant. There is a metric changer (button) in every column. It does not look good to me. There is an option in tables to show/hide headers. This option could be availabe in this case.

The question is: Is it possible for QlikTech to have merged header cells? It would be awsome to see what is the metric, but only once.

Christian