topic Ignore filters in dimensions in App Development

Ignore filters in dimensions

Gestion-PSD — Sat, 16 Nov 2024 19:04:06 GMT

Hi all!

I'd been looking through Community about that but I couldn't find solution to our problem:

Facts:
- We've a dimension-only straigh table with 2 columns ('client' and 'Phone').
- We also have a filter pane with date dimensions ('ThisMonthFlag', ...)
Question:
- What can we do to make 'client' and 'phone' dimensions not no be affected by date filters?
Note:
- There are not measures in the straigh table, so set analysis {<ThisMonthFlag=,...>} on functions doesn't run.
- We tryed aggr on dimensions like "=aggr(ONLY({<ThisMonthFlag=>}Phone),Pone)" and dimensions don't ignore ThisMonthFlag selections
- We also tryed "=IF(ThisMonthFlag=1,Phone,Phone)" without success

sunny_talwar — Fri, 21 Feb 2020 13:21:54 GMT

Add a dummy expression like this Avg({<ThisMonthFlag = , ...>} 1)

Gestion-PSD — Mon, 24 Feb 2020 11:03:38 GMT

Hi Sunny.

Thanks for oyur reply, but it doesn't an option.

We can't show any field but 'Client' and 'phone' dimension (design requeriments)

I tryied to add a measure similar to yours and mark it as "Show colum if" = false() (to avoid it visibility) but it doesn't work.

Actually, with the measure visible, it's OK and dimensions aren't affected by filters, but when I hide it, dimensions are affected again.

Regards,

sunny_talwar — Mon, 24 Feb 2020 12:29:56 GMT

Can a client have multiple phones? If not, then may be you can use phones as an expression instead of a dimension?

Gestion-PSD — Mon, 24 Feb 2020 12:45:44 GMT

Hi!

"Can a client have multiple phones?" Yes, absolutelly.

Every client has multiple phones, but every phone belongs to one client

sunny_talwar — Mon, 24 Feb 2020 12:47:11 GMT

Oh that is true... may be use phone as a dimension and Only({<ThisMonthFlag = , ...>} Client) as your expression

Gestion-PSD — Mon, 24 Feb 2020 12:53:35 GMT

Hi Sunny

That's working!

Thanks!