how to exclude values with conditions!

[#1]

Hello every one ,

Every day I learn a new thing in Qlikview ; today I have to exclude values from a tables with condition.

When "Product_Field"=value then  exclude the product .

When I have CA=0 , I want to exclude the product from the table . like this screenshot:

[MK_QSL]

If you want to do SUM of Sales with Excluding Germany....

Use the same in your application.

SUM({<Country -= {'Germany'}>}Sales)

[#3]

I want to do : sum ( sales) when CA >0

( CA is calculation )

[its_anandrjs]

Where in front end you want to do this logic. On front end do like

Expression:-

Sum( if(CA>0,sales,0) 

[#5]

You may also use conditions like this:

sum({<Product={"=sum(CA)>0"}>}sales)

in that case  sum(CA)>0 is search string

Find set analysis in help and look on "Set Modifiers with Advanced Searches"

regards

Darek

[#6]

Thank you for your response , but it doesn't work with my Dimension .

Im using "Product" like dimensions and I want to display only Products with CA >0.

I don't need to show others .

[#7]

I trying to activate condition of the  dimension "Produit", if(Sum(CA)>0,Produit,0), else the product will be Hiden.

This solution doesn't work.

[dseelam]

Add a Calculated Dimension Where CA>'0' AND Suppress Nulls

[maxgro · Accepted solution]

replace Produit with a calculated dimension

=if(aggr(sum(CA),Produit)>0,Produit)

and then suppress when value is null

I suppose Dariusz's answer works if you apply the same logic to all expression (try with one expression and let we know)

[#10]

It still should work ....