topic hiding null values in measures in App Development

hiding null values in measures

Thu, 06 Aug 2015 19:36:15 GMT

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 ?

Re: hiding null values in measures

sinanozdemir — Thu, 06 Aug 2015 20:24:11 GMT

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.

Re: hiding null values in measures

ogster1974 — Thu, 06 Aug 2015 22:01:15 GMT

‌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

Re: hiding null values in measures

Fri, 21 Aug 2015 19:36:22 GMT

Thanks for your answer.

I need is to hide null values in the measures.

In dimension this is possible, but in measure not.

Thank

Re: hiding null values in measures

Sat, 09 Jan 2016 22:19:15 GMT

Thanks Andy - your response just helped me as well!

Re: hiding null values in measures

tomovangel — Thu, 14 Dec 2017 10:28:45 GMT

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