Th way of excluding from showing in the pivot table!

[nevilledhamsiri]

Dear Expert guys!

I am crazy to learn every bit of thing that I find in the process. I am a learner & please take time to response to me.You all guys have been giving your helping hand  for every issue I forwarded.I am applying them in my work & learn more on them. Here as per the data given in the pivot table, I need to exclude records which do not have  sales against Refund premium. In other words all rows which only carries Refunds to be excluded. Please explain how i could do this step by step.

Thanks

Neville

[Anil_Babu_Samineni]

One way could be

If(Refund_Premium = Sales, Sum(Sales))

[Peter_Cammaert]

Modify all expressions (except for Sum(Sales) itself) to check for Sum(Sales) > 0.

For example, the two visible columns could become (using placeholders as we cannot see what your expressions actually look like):

=IF(Sum(Sales) > 0, expressionRefund_Premium)

and

=IF(Sum(Sales) > 0, expressionSalesRatio)

When all expressions for a particular combination of dimension values return either 0 or NULL, that row will be suppressed by QlikView.

[omkarvamsi]

Hi ,

please try below expression in place of sum(sales)

if(sum(Sales)<>0,sum(Sales))

Regards

Om

[farru_scorpio · Accepted solution]

omkar is correct.