topic filter pivot table with original column in QlikView

filter pivot table with original column

Anonymous — Wed, 20 Dec 2017 10:55:56 GMT

Hello community,

In a pivot table i'm trying to build an expression, in this expression I want to sum column A values when column B is equal to X. column B is also a pivoting dimension on the same table so I've tried with:

=sum( if(columnB=X, Alt(columnA,0) ))

=sum( {1<columnB= {X}>} Alt(columnA,0) )

but the expression only consider the values of columnB of that part of the chart.

I would like to consider all the data of the original table ignoring the current chart position.

I'm trying to be as clear possible but I'm still learning basic qlik's terminology.

Also I'm not sure about the place to post this in

Thanks for any advice

Re: filter pivot table with original column

el_aprendiz111 — Wed, 20 Dec 2017 19:09:19 GMT

Hi Ricardo

Would you be able to share a sample?

Re: filter pivot table with original column

Anil_Babu_Samineni — Thu, 21 Dec 2017 00:56:07 GMT

May be this?

=sum( {1<columnB *= {X}>} Alt(columnA,0) )

Re: filter pivot table with original column

Anonymous — Thu, 21 Dec 2017 11:03:04 GMT

I found out that the TOTAL keyword was what I was searching so my solution is:

=sum( TOTAL if(columnB=X, Alt(columnA,0) ))

Re: filter pivot table with original column

Anil_Babu_Samineni — Thu, 21 Dec 2017 16:50:38 GMT

Please mark yourself as correct answer