Qlik Community

QlikView Deployment

Discussion Board for collaboration related to QlikView Deployment.

maurorinaldo
New Contributor

Again, sum of columns on Pivot table

I read some old answers but I cannot reach the solution.  Please help me..

I have a pivot table with sum ov value for name and years

The "S" colums as "if V is more then 5.000  then 1 else 0 "

I would like to have the sum/count of each "S=1" on Total colum, not always 1   (ex. last row should be 2 , since 2 columns have 1)

Thk

Mauro

1 Solution

Accepted Solutions

Re: Re: Re: Again, sum of columns on Pivot table

See attached qvw.


talk is cheap, supply exceeds demand
4 Replies

Re: Again, sum of columns on Pivot table

Can you post an example document with some data?


talk is cheap, supply exceeds demand
maurorinaldo
New Contributor

Re: Re: Again, sum of columns on Pivot table

Here an example

Re: Re: Re: Again, sum of columns on Pivot table

See attached qvw.


talk is cheap, supply exceeds demand
maurorinaldo
New Contributor

Re: Re: Again, sum of columns on Pivot table

Thank you very much!

Community Browser