topic Re: How to display all the values in a dimension in App Development

How to display all the values in a dimension

danimarc12 — Wed, 29 Sep 2021 16:14:38 GMT

Hello everyone!

I have the following issue: I want to create a simple table composed of a column with a dimension which has all the values of my dataset and a secon column with a measure which shows an "X" if the dimension has a data or "O" if not.

I'm gonna show you:

"Cliente" is my dimension but, as you can see, if I select an year from my filter, I'm gonna exclude the values with gray background. My goal is to display all of them and display in another column if they are in the year I select.

I hope I've been clear.

Best regards!

Re: How to display all the values in a dimension

stevejoyce — Wed, 29 Sep 2021 18:32:25 GMT

Cliente can be your dimension. Use this as your expression:

pick(count({1} distinct 1) * count( distinct 1) + 1, 'O', 'X')

Re: How to display all the values in a dimension

danimarc12 — Thu, 30 Sep 2021 08:45:07 GMT

I still can see the gray fields.

Re: How to display all the values in a dimension

stevejoyce — Thu, 30 Sep 2021 11:25:08 GMT

ok in this scenario where you want to be able to filter also, you need to have this field dis-associated from the data model.

Create an island table like:

Cliente_island:

load

Cliente as Cliente_All

resident <data source>

;

Then your object's dimension will be Cliente_All field.

And your expression will be:

pick(count({1} distinct 1) * count( {<Cliente_All = P(Cliente) >} distinct 1) + 1, 'O', 'X')