Use list element without dynarange as filter option?

SaraLM · Apr 17th 2019, 9:54am

Hi there,

is it possible to use a list box without a dynarange?

I read that it should be used with a dynarange (knowledgebase.jedox.com/knowle…e/report-list-dynaranges/ ) but I´d like to use it in a palo.data formula without a dynarange.

Thanks in advance.

Sara

kiran.gs · Apr 18th 2019, 3:21am

You can use a list box without a dynarange also. However, it becomes a very static report.

The thing is that (in case of a multiselect list box) the output is an array, and hence, dynarange is a good option to use. If you do not want to use dynarange, you can use array functions like index. Please see attachment.

SaraLM · Apr 18th 2019, 8:37am

Thanks for your answer!

Sorry I didn´t make myself clear in the first step. I found that solution myself, there is also an article in the knowledgebase (knowledgebase.jedox.com/knowle…menu-tools-form-elements/ ) but I don´t know how to integrate the array function in a palo.data.

Is it possible at all?

kiran.gs · Apr 18th 2019, 8:44am

If you are trying to use array formula for retrieving, say sum of all values within the multi-select, you can use PALO.DATAV to sum the values across the array.

So, the format would be:

=SUM(PALO.DATAV(DB,Cube,Element,Element,Array,...,Element))

Hope this helps.

SaraLM · Apr 25th 2019, 11:32am

This helps a lot - thanks!

It works perfectly now!!

Use list element without dynarange as filter option?

Use list element without dynarange as filter option?

Share

Tags