Perspective Reporting DataKey True/False for Nested Query

General Discussion
1

Hi,

I am currently using Visible property with Dynamic Data Key. I need to set it to false if nested query Value is Null.
I have 3 level nested queries,

  1. Location
    1.1 Data
    1.1.1 Details

The visible property I am trying to use is in Details table. If Type Column value. in Data Table is null then False. So I can show 1.1.1 Table only on specific instances where data.Type column value is not null.
I am currently using, Location.Data.Type!=" "?"True".

Its not working Can you please help with this? Thanks

2

It would probably help for you to read ReportMill's document on Keychain Expressions first. (ReportMill is the reporting engine we use)

ReportMill will evaluate NULL values as false and non-NULL as true in keychains, so I suspect you can simplify your keychain. I don't fully understand your data and report setup, but it might be that Type is sufficient here.

1 Like