topic Re: Hide a dimension (Null Values) in QlikView

Hide a dimension (Null Values)

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

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???

Re: Hide a dimension (Null Values)

sunny_talwar — Fri, 23 Mar 2018 16:49:30 GMT

May be like this

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

Re: Hide a dimension (Null Values)

Anonymous — Fri, 23 Mar 2018 16:53:39 GMT

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

Re: Hide a dimension (Null Values)

YoussefBelloum — Fri, 23 Mar 2018 16:58:31 GMT

EDITED

or this:

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

Re: Hide a dimension (Null Values)

sunny_talwar — Fri, 23 Mar 2018 17:01:32 GMT

This will not remove Supplier 2

Re: Hide a dimension (Null Values)

Anonymous — Fri, 23 Mar 2018 17:05:19 GMT

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)

Re: Hide a dimension (Null Values)

sunny_talwar — Fri, 23 Mar 2018 17:07:07 GMT

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

Re: Hide a dimension (Null Values)

Anonymous — Fri, 23 Mar 2018 17:08:36 GMT

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

Re: Hide a dimension (Null Values)

shiveshsingh — Fri, 23 Mar 2018 17:10:16 GMT

May be this can help

what is alternate states in Qlikview ?

Re: Hide a dimension (Null Values)

sunny_talwar — Fri, 23 Mar 2018 17:11:49 GMT

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