topic Re: set expression with aggr() in App Development

set expression with aggr()

levente81 — Wed, 14 Dec 2022 17:57:47 GMT

Hi there,

Please someone let me know how could happen that I get back values based on selection when I explicitly ask for all values regardless selection....

aggr( {1} only( {1} Dateval),Dateval)

What do I not see here which allows current selection to creep back to my displayed list of items?

While it is not working as I expect there is an other simple calculation:

Count({1} Dateval)

where {1} set identifier works fine, and I always get total count of items regardless of selection. These 2 are "running" in parallel, and the only difference I see is that latter is working fine, while the earlier is not...

My ultimate goal is to add there a complex dynamic date filter expression instead of {1} set identifier once I understand why this simple is not working the way I think it should...

Thanks, Levente

Re: set expression with aggr()

alextimofeyev — Thu, 15 Dec 2022 13:37:46 GMT

Hi,

can you explain in a bit more detail what you are trying to accomplish? It seems that you are trying to obtain an array of distinct field values corresponding to some filter other than current selections. What are you going to do with it?

Re: set expression with aggr()

agigliotti — Thu, 15 Dec 2022 15:07:36 GMT

Hi @levente81 ,
As @alextimofeyev said you should provide more info about your actual result and the expected one.

Best Regards

Re: set expression with aggr()

levente81 — Fri, 16 Dec 2022 15:40:19 GMT

Hi Agigliotti,

There is a simple situation, what I hope can be answered. Using this definition (

aggr( {1} only( {1} Dateval),Dateval)

) in a table object as dimension, what shall I see when I select certain Dateval values:

- all Dateval values

- or only those that I selected?

If the answer is always all as {1} is used, then comes my original question: How could happen, that my table responds to active selection?

Best regards,

Levente

Re: set expression with aggr()

agigliotti — Fri, 16 Dec 2022 15:52:07 GMT

It would be easier if you could post a sample app with mock data.

Re: set expression with aggr()

alextimofeyev — Fri, 16 Dec 2022 17:23:17 GMT

I think it will not work if you only have this dimension in your table. If you add a measure that ignores selections too, than all values in your dimension will show.

If you really don't need that measure in the table, you can "hide" it by setting the label to '' and text color to white().