topic Ignore user selection but set a value on the same field using set analysis in App Development

Ignore user selection but set a value on the same field using set analysis

javi_martinez — Wed, 08 Mar 2023 15:46:26 GMT

Hi all,

I want to do a measure for sum a value but I want to ignore user selection on a filter and set this filter to an specific value.

I show you what I want to:

sum({< field_a= {"7"}
    , field_b -- ignore user selection
    , field_b = {"ABCD"} -- set to a specific value
>} measure_a)

In this case, I want to ignore the user selection on "field_b" and set it with a specific value, "ABCD" .

I don't how to do it ...

Can you please help me with that?

Thanks!

rpennacchi — Wed, 08 Mar 2023 16:27:38 GMT

Hi, Javi,

When you specify a filter for a field in set analysis, you are already disregarding user's selection for that field. So you only need to do this:

sum({< field_a= {"7"}
    , field_b = {"ABCD"}
>} measure_a)

javi_martinez — Wed, 15 Mar 2023 13:25:51 GMT

Hmm it doesn't work, but I don't know why...

I mean, for example if I filter FIELD_B to "1234" and I use that set analysis the measure shows empty.

rpennacchi — Thu, 16 Mar 2023 00:52:52 GMT

Can you send a screenshot of your data model?