Hide dimension value

[#1]

Hi guys!

I have a  requirement: the table must show current month as a dimension and total for the year.

I tried to solve this problem with the calculated dimension:

=if(Month_name=vCurMonth,Month_name)

and ticked show total.

I got the straight table like:

Period	Bench 2015 vs Budget 2015, %	Bench 2015 vs Budget 2015, USD
Total Year	77%	ok
May	76%	ok
0	77%	ok

However i dont need ths null value in dimension to be shown. However i need it for Total Year calculation.

Any ideas how to hide this value without affecting calculations?

[Anonymous]

Hi,

Have you tried checking the Suppress when value is null option in the dimensios tab?

Regards,

Greeshma

[#3]

When I suppress it, i dont get the correct total. I need total for all months

[#4]

try this

if (Len(YourField) > 0, YourField)

[#5]

Unfortunately, it isn't what is needed

[#6]

if(isnull('fieldname',alt(1)));

[Gysbert_Wassenaar]

Can you post a qlikview document that demonstrates the problem?