hiding null values in measures

[#1]

In QlikView, we have the option of hiding null values ​​in expressions.

In Sense there is no such option for measures ( version 1 or 2). 

Anyone know if planning to implement this option in the short term ?

[sinanozdemir]

Hi Guillermo,

It is on the right pane and you need to go the column and expand it. Then you will see the option for "Show null values":

Hope this helps.

[ogster1974]

‌The way I've got round this is by creating a master dimension with an if statement.

IF(AGGR(<my expression>, my dimension), my dimension, null())

Then I put this in as my dimension and include the measure expression.  I can then uncheck the show null values from my dimension and the null values will have beenremoved.

Regards

Andy

[#4]

Thanks for your answer.

I need is to hide null values in the measures.

In dimension this is possible, but in measure not.

Thank

[#5]

Thanks Andy - your response just helped me as well!

[tomovangel]

Hello Mr. Andy Weir

I have tried to apply your solution to my problem with the following logic

=IF(AGGR((Sum([Amount LocCur])-Sum([Paid LocCur])='0'),Customer), Customer, null())

where Amount LocCur is - Invoices amount in Local Currency
Paid Loc CUr is - Amount paid in local currency.

I am trying to eliminate all Customers and Invoices in which the Amount Due ( Amount Local Currency - Amount Paid)=0..

Thanks for your time