topic Hidden dimension and calculation in QlikView

Hidden dimension and calculation

vivientexier — Tue, 27 Sep 2011 08:08:03 GMT

	Dimension level 2	Sum ( A & B )	Sum ( C ) / Sum ( A & B )
Alpha	A	A	Null
Alpha	B	B	Null
Alpha	Null	Null	C

Hi,

How can I hide the third line of my table (where dimension level 2 = null) and keep the result of my expression (Sum(C) / (Sum A & B) in the same time ?

I can make all values of the third line equals to null but the line doesn't not disappear.

In table properties, if I chose to not display null values the line disappear but my calculation ( Sum(C) / Sum(A & B) ) as well.

How can I hide the third line and keep my result ?

Hidden dimension and calculation

SunilChauhan — Tue, 27 Sep 2011 08:15:50 GMT

supress Dimension level 2

if([Dimension level 2]<>'Null',[Dimension level 2])

then supress null

Hidden dimension and calculation

vivientexier — Tue, 27 Sep 2011 09:51:18 GMT

Thank you for your answer.

However, I can't suppress Dimension level 2 because I still need to see A & B.

The if statment change Sum( C ) to null.

An easy way of doing it would be to create two tables but it would be nice to have only one table.

Hidden dimension and calculation

SunilChauhan — Tue, 27 Sep 2011 10:02:56 GMT

can you upload a sample file and out put required.