Show rows only if a value is "null"

[fgirardin]

Hello all,

I'm trying to modify one of my document.

The main view looks like this:

I separated the view into 2 specific tables (one for buying price, the other for selling price) for ease of use (and also to avoid some null values if the .

I use the following expression to separate PA from PV

Count({$<FIELD={"PA"}>}FIELD)    or    Count({$<FIELD={"PV"}>}FIELD)

My user needs to be able to quickly check the current prices for most of our articles. The only way I can do this is to show ONLY the rows that have a "null" value in "End Date" (wich indicate that it is the current price)...

In this example, I'd like to see only the third row (left table) and the fourth and fifth (right table)

Is there a way to show only the null value in those 2 tables ? (note that I cannot modify the script since I need all dates for other pages)

Let me know if I'm not clear.
Thank you for your help

[beck_bakytbek]

Hi Fabien

Do you want to see instead of this sign (--) only Zero (0) within your Rows?

beck

[sunny_talwar]

Would it be possible to share your application to help you better?

[muthukumar77]

Hi,

You can do in script level.

Eg:

Load

....

....

Table

Where Date_fin = 'Null';

I hope it will work.

[trdandamudi]

if you want to get the null "ONLY the rows that have a "null" value in "End Date" :

{$<[End Date]={"=Len(Trim([End Date])) = 0"}>}

Hope this helps,,,

[Digvijay_Singh · Accepted solution]

You may try using calculated dimension in both the tables as below-

If(Len(EndDate)<=0,[Cle Principale])

[fgirardin]

Thank you for your input.
If I add this calculated dimension, here is my result (note that "--" is what I use for NULL in my tables)

This seems to work except for the fact the the other rows are still shown. Is there a way to hide those ?
Note that I checked "Delete Null values". If I don't, the result is as shown:

Thank you again for your help

[fgirardin]

Hi,

"--" is what I chose to show when the values are NULL
What I'd like is to see only the rows that contains NULL in END DATE

Thank you

[fgirardin]

Hello,

Sadly, no.

Thank you

[fgirardin]

Hello,

Is there a way to do it for a specific table only or should I create a new document that use this script specifically ?
I need to have all the dates for other pages so modifying the script on this document is not possible

Thank you