Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

koushikganapath
Contributor III

Partial Sums in Pivot Table

Hi

I am using the following Pivot table in my dashboard,

Capture.PNG

The user wants to see Total only if there is more than one Purchase Order coming under a customer.

In the above example I want to show Total only for the Customer 'Smith' and not 'Greyson'.

Is there a way to do so?

Thanks

1 Solution

Accepted Solutions
MVP
MVP

Re: Partial Sums in Pivot Table

Try like:

If(Dimensionality()=1 and Count([Purchase Order])>1,Sum(Sales), if(Dimensionality()>1, Sum(Sales)))

Untitled.png

View solution in original post

3 Replies

Re: Partial Sums in Pivot Table

Hi Koushik,

Try,

If(Dimensionality()=1 and Customer='Smith', Sum(Sales),

If(Dimensionality()<>1, Sum(Sales)))


Edit:


Sorry. I didn't read your question fully, Check the below expression


If(Dimensionality()=1 and Count(Order_Type)>1, Sum(Sales),

If(Dimensionality()<>1, Sum(Sales)))


MVP
MVP

Re: Partial Sums in Pivot Table

Try like:

If(Dimensionality()=1 and Count([Purchase Order])>1,Sum(Sales), if(Dimensionality()>1, Sum(Sales)))

Untitled.png

View solution in original post

MVP
MVP

Re: Partial Sums in Pivot Table

Use this calculated dimension:

Aggr(If(Count([Purchase Order]) > 1, Customer), Customer)

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein