topic Re: Hide dimension value in QlikView

Hide dimension value

Tue, 05 May 2015 11:23:59 GMT

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:

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 — Tue, 05 May 2015 11:30:46 GMT

Hi,

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

Regards,

Greeshma

Tue, 05 May 2015 11:33:32 GMT

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

Tue, 05 May 2015 11:33:59 GMT

try this

if (Len(YourField) > 0, YourField)

Tue, 05 May 2015 11:39:49 GMT

Unfortunately, it isn't what is needed

Tue, 05 May 2015 11:44:03 GMT

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

Gysbert_Wassenaar — Tue, 05 May 2015 11:52:23 GMT

Can you post a qlikview document that demonstrates the problem?