topic Re: Pivot Table: how to show expression only in total in QlikView

Pivot Table: how to show expression only in total

agigliotti — Tue, 30 Jul 2013 15:32:16 GMT

Hello,

I have a pivot table with 2 dimensions and two expressions.

I need to show the second expression value only in total column and finally I did it using SecondaryDimensionality() = 0 as condition.

Now I have to hide all columns of second expression values for each value of second dimension and show it only in total.

How can I achieve it ?

Many thanks in advance.

Best Regards

Andrea

Re: Pivot Table: how to show expression only in total

massimilianoruf — Tue, 20 May 2014 08:20:56 GMT

I have the same problem, have you found any workaround?

Re: Pivot Table: how to show expression only in total

Anonymous — Tue, 20 May 2014 08:23:36 GMT

Can you provide a sample data with output required......

Re: Pivot Table: how to show expression only in total

cfz — Tue, 20 May 2014 08:35:40 GMT

Hi Andrea,

I hope the attached example answers your question.

Cheers

Carlos

Re: Pivot Table: how to show expression only in total

massimilianoruf — Tue, 20 May 2014 08:43:43 GMT

Hi Nitin,

my current situation is the following:

The output required will be the following:

Thanks,

Massimiliano

Re: Pivot Table: how to show expression only in total

agigliotti — Wed, 21 May 2014 11:18:20 GMT

Hi Carlos,

I taked a look at your example and it's useful.

See the pivot table below:

where i'm using dimensions and expressions with conditional option enabled.

I need to add a column as "Total divided by the number of dimension values" that in this case is 7 (Esercizio 2009, Esercizio 2010, Esercizio 2011, Esercizio 2012, Esercizio 2003, Esercizio 2014, Esercizio 2015).

The new column should works as below for "CT01 ENERGIA" row:

Totale esercizio Media esercizio

29.465.482,92 4.209.354,70 (that is 29.465.482,92 / 7)

How is possibile to achieve it ?

Many thanks in advance.

Best Regards

Andrea

Re: Pivot Table: how to show expression only in total

agigliotti — Thu, 22 May 2014 10:01:51 GMT

The only way to hide column is to apply the expression color to white.

Re: Pivot Table: how to show expression only in total

Mon, 13 Feb 2017 17:17:02 GMT

Hi,

Was there any answer to this? I am trying exactly the same in my pivot table but can't find the solution.

I have used SecondaryDimensionality but that hides everything. I want to display only the total column.

Hi Stefa,swuehl‌ would you know the workaround here? exactly same example as Massimiliano above table.

Many thanks,

Marcelo