topic Re: why is this set analysis not working? in App Development

why is this set analysis not working?

rcandeo — Sat, 16 Nov 2024 20:26:07 GMT

I have this expression that works bringing amount

sum({$<YearMonth_LayOut={"$(=$(vYearMonth))"}>} amount)

But it brings only actual year/month and I need to see the months till actual month not including it. So I change the expression to

sum({$<YearMonth_LayOut={"<$(=$(vYearMonth))"}>} amount) and it brings me nothing

vYearMonth has the result = 2019/07 and I have data for YearMonth_LayOut since last year

Any idea what is wrong in my expression please?

Re: why is this set analysis not working?

jonathandienst — Thu, 18 Jul 2019 05:15:41 GMT

Is the [YearMonth_LayOut] field a numeric (like a date or dual value)?

Re: why is this set analysis not working?

rcandeo — Thu, 18 Jul 2019 11:04:46 GMT

No, it is a text field like ˜2019/07˜

Re: why is this set analysis not working?

tresB — Thu, 18 Jul 2019 11:19:03 GMT

And are you also expecting a textual/string comparison when comparing with </> sign? I guess not, right? Try to create a numeric/dual field in the script and use the same in set analysis here.

Re: why is this set analysis not working?

rcandeo — Thu, 18 Jul 2019 11:39:41 GMT

Are you telling me the problem is the ˜/˜ or comparing a text field?

Just to understand what I have to do

I could bet that this comparison should work, but this can explain my day lost trying to make it happen

Re: why is this set analysis not working?

rcandeo — Thu, 18 Jul 2019 11:52:16 GMT

I changed the field to numeric without the "/" and did not get how to work

this way works selecting only actual year/month

YearMonth_Num_LayOut={"$(=$(vYearMonthNum))"}

but if I try to see only previous ones, nothing comes:

YearMonth_Num_LayOut={"$(<=$(vYearMonthNum))"}

Re: why is this set analysis not working?

Gabriel — Thu, 18 Jul 2019 12:28:02 GMT

Hi,

Are you able to provide sample data or qvf file?

This might help to resolve

Re: why is this set analysis not working?

rcandeo — Thu, 18 Jul 2019 14:14:12 GMT

I am in a client and unfortunatelly I cannot share their data, but see the image with the table view and variable view if can help you and thank you in advance

Re: why is this set analysis not working?

ravishankarqv — Thu, 18 Jul 2019 14:51:16 GMT

Hi Rcandeo,

Try this.
YearMonth_Num_LayOut={$(#vYearMonthNum)}

HTH
Ravi

Re: why is this set analysis not working?

pepecc — Thu, 18 Jul 2019 15:43:54 GMT

I would have written the expression like this:

sum({$<YearMonth_LayOut={"<'$(vYearMonth)'"}>} amount)

or maybe

sum({$<YearMonth_LayOut={"<$(vYearMonth)"}>} amount)

Think that you do not have to opperate with the value loaded into the variable, then you just need to substitute its contain in set analysis.

Hope it helps.

Re: why is this set analysis not working?

rcandeo — Thu, 18 Jul 2019 22:05:55 GMT

Unfortunatelly no numbers here

Re: why is this set analysis not working?

rcandeo — Thu, 18 Jul 2019 22:10:16 GMT

the first expression came with no numbers and the second did no respected the selection and all months were there