LINKTOFILTEREDVIEW() is not supporting booleans

[interact-yugal]

I’m encountering an issue with LINKTOFILTEREDVIEW(). When I include the condition [Archived]=FALSE, the formula fails to display any records.

This condition was added today, and the formula works correctly without it.

Does anyone know of a quick solution that doesn’t involve using slicers?

The following expressions are working:

Pending Documentations

IF(
CONTEXT(“ViewType”) = “Card”,
LINKTOFILTEREDVIEW(
“0 - Documentations Card”,
AND(
IF(
[Requires Signature],
[Documentation Status] <> “Signed”,
[Documentation Status] <> “Final”
),
[Documentation Status] <> “Cancelled”
)
),
LINKTOFILTEREDVIEW(
“0 - Documentations Table”,
AND(
IF(
[Requires Signature],
[Documentation Status] <> “Signed”,
[Documentation Status] <> “Final”
),
[Documentation Status] <> “Cancelled”
)
)
)

Final Documentations

IF(
CONTEXT(“ViewType”) = “Card”,
LINKTOFILTEREDVIEW(“0 - Documentations Card”, [Documentation Status] = “Final”),
LINKTOFILTEREDVIEW(“0 - Documentations Table”,
[Documentation Status] = “Final”)
)

The following expressions are not working:

Pending Documentations

IF(
CONTEXT(“ViewType”) = “Card”,
LINKTOFILTEREDVIEW(
“0 - Documentations Card”,
AND(
[Archived] = FALSE,
IF(
[Requires Signature],
[Documentation Status] <> “Signed”,
[Documentation Status] <> “Final”
),
[Documentation Status] <> “Cancelled”
)
),
LINKTOFILTEREDVIEW(
“0 - Documentations Table”,
AND(
[Archived] = FALSE,
IF(
[Requires Signature],
[Documentation Status] <> “Signed”,
[Documentation Status] <> “Final”
),
[Documentation Status] <> “Cancelled”
)
)
)

Final Documentations

IF(
CONTEXT(“ViewType”) = “Card”,
LINKTOFILTEREDVIEW(
“0 - Documentations Card”,
AND([Archived] = FALSE, [Documentation Status] = “Final”)
),
LINKTOFILTEREDVIEW(
“0 - Documentations Table”,
AND([Archived] = FALSE, [Documentation Status] = “Final”)
)
)

[WillowMobileSys]

Those expressions, as far as i can tell, should be fine. I think you need to double-check the data. Do any rows have the physical value of “false” assigned.

The value of FALSE and <> are not the same.

If you wish to treat blanks the same as FALSE, for this expression, then try changing it to

...[Archived] <> TRUE...

To make testing easier, create a temporary Slice against the same base dataset. Your expressions are simply a filtering expressions. Cut and past one of them as the Slice criteria and view the reuslting data. Adjust the expression as necessary to make it work and then you’ll know what to use in the LINKTOFILTEREDVIEW() functions.

I hope this helps!

[interact-yugal]

I totally agree with you that [Archived] <> TRUE is the safer way to go, especially since it treats those blank “Archived” fields as “unarchived.” Good catch on handling those edge cases!

I went ahead and updated the expression to this:
IF(
CONTEXT(“ViewType”) = “Card”,
LINKTOFILTEREDVIEW(
“0 - Documentations Card”,
AND(
[Archived] <> TRUE,
IF(
[Requires Signature],
[Documentation Status] <> “Signed”,
[Documentation Status] <> “Final”
),
[Documentation Status] <> “Cancelled”
)
),
LINKTOFILTEREDVIEW(
“0 - Documentations Table”,
AND(
[Archived] <> TRUE,
IF(
[Requires Signature],
[Documentation Status] <> “Signed”,
[Documentation Status] <> “Final”
),
[Documentation Status] <> “Cancelled”
)
)
)

And guess what? It worked!

Thanks for taking the time to help me out.

[Suvrutt_Gurjar]

@WillowMobileSys

If you wish to treat blanks the same as FALSE, for this expression, then try changing it to

...[Archived] <> TRUE...

Nice catch @WillowMobileSys