Hide a dimension (Null Values)

[Anonymous]

Hi All,

I have a table I need to hide some dimensions.

Dimensions - Product
                    - Supplier

Expression - Total Spend

(Current Pivot table in my presentation)

Product (selections)	Supplier 1	Supplier 2
1	$10	$20
2	$10	N/A
Total	$20	$20

So in this scenario - Supplier 2 is not manufacturing BOTH products, hence I wish for them to be suppressed completely. How do I accomplish this???

[sunny_talwar]

May be like this

Sum({<Supplier = {"=Count(Product) = Count(TOTAL Product)"}>}Spend)

[Anonymous]

I put that in the expressions? Okay...will try

[YoussefBelloum]

EDITED

or this:

Sum({<Supplier = {"=Sum(Spend)>0"}>}Spend)

[sunny_talwar]

This will not remove Supplier 2

[Anonymous]

Sunny quick question - and if I want to hit the set expression for the selections of Product (as stated in my table), I put in $ in the statement right?

so like this?

Sum({$<Supplier = {"=Count(Product) = Count(TOTAL Product)"}>}Spend)

[sunny_talwar]

Unless you have alternate state in your app (specifically on this tab/chart), you don't really need $ because $ and not having anything is equivalent to each other. Things start to get complicated when you introduce alternate state into the picture

[Anonymous]

sorry I am not following what you mean by alternate state.

[shiveshsingh]

May be this can help

what is alternate states in Qlikview ?

[sunny_talwar]

Just a way to do comparison between the same data set...

https://help.qlik.com/en-US/qlikview/November2017/Subsystems/Client/Content/Alternate%20States.htm