topic Re: Variables in Set Analysis in App Development

Variables in Set Analysis

mena_ricardo — Wed, 19 Jun 2019 08:31:56 GMT

Hi, I need help.

I have this variable in my dashboard:

Name:

vL.MaxDatePeriod

Definition:

max([Period])

Also I have a table with two fields:

Field 1: [Period]

Field 2: $(vL.MaxDatePeriod)

This is correct, because the table shows:

Field1 Field2

201904 201904

201905 201905

Now, I try to add a new column with this formula, where I need to count distinct operations by period:

Count(distinct {<[ExpiryDate_NUM]={">$(vL.MaxDatePeriod)"}>} [Operations])

*ExpiryDate_NUM contains 201904, 201905, 201906.....

But the result of the formula is 0. If I change the definition of the variable vL.MaxDatePeriod and I put =max([Period]), the result of the formula is 378, but is the same value for both rows because the result of the variable vL.MaxDatePeriod is always 201905

Anybody knows a solution? I need this formula because I need to use it in other chart

Re: Variables in Set Analysis

anushree1 — Wed, 19 Jun 2019 10:02:39 GMT

Can you please share the sample application to check the definition of variable and field values

Re: Variables in Set Analysis

mena_ricardo — Wed, 19 Jun 2019 10:24:30 GMT

In the attachment

Thanks!

Re: Variables in Set Analysis

mena_ricardo — Wed, 19 Jun 2019 10:24:52 GMT

In the attachment

Thanks!

Re: Variables in Set Analysis

anushree1 — Wed, 19 Jun 2019 14:10:16 GMT

Please check the attached

is this what you are looking for?

Re: Variables in Set Analysis

mena_ricardo — Wed, 19 Jun 2019 15:01:02 GMT

No, because the value of the variable "vL.MaxDatePeriod" is always 201905:

In the table, I need to show:

Period vL.MaxDatePeriod

201904 201904

201905 201905

If I change the definition of the variable and I write : max([GTB_BOARD_EXPFINANCE_HIST.Period]), without the equal symbol "=":

The final result is not OK.

Thanks for your help