Condition for missing value

[Anonymous]

Good day!

My task is to make conditions for missing value.

I have sales points and make pivot table with such dimensions:

1. Sales Point

2. Date.

There are some dates with sales "-". It's missing value. Is there any way to set '!' for missing value in expression?

Such as.. if(sum(sales)  <condition> for missing value,'!','V')

[Anonymous]

Thank you!

But it get me "-", not  '!'

[#3]

Then you can try comparing the string. like if(sum(sales) = '-','!','V')

[Anonymous]

Can you share your Sample QVW please.

[Anonymous]

i can not compare missing value with "-", because it's not string value

[PrashantSangle]

Hi,

If you want change - to ! then go to presentation tab

change missing symbol and Null Symbol to "!" instead of "-"

Or try in expression

like

if(not isnull(expression),expression,'!')

or

if(len(trim(expression))>0,expression,'!')

Regards

[Yoda300_]

Hi, did u find a solution ? I have the same issue, thanks to reply