topic Cleaner and better set analysis in App Development

Cleaner and better set analysis

Simon4 — Thu, 22 Dec 2022 08:46:27 GMT

Dear all,

I have a margin formula with set analysis. this is the syntax:

How can I make this cleaner?

It is neccesairy because the set analysis identifier (1) does not work. when I select other weeks than "currentweek" it shifts to zero.

Thank you in advance,

simon

Re: Cleaner and better set analysis

Michiel_QV_Fan — Thu, 22 Dec 2022 15:12:41 GMT

is the peildatum a value in the currentweek? if your data is not deriving these to date fields, peildatum and currentweek from a master calendar then I would expect that these 2 cancel each other and result in the 0 value.

What is your question in making this cleaner? Which part do you want to clean?

Re: Cleaner and better set analysis

Simon4 — Thu, 22 Dec 2022 15:15:43 GMT

no peildatum and currentweek are two different values.

my end goal is to make it ignore filters. now when i set the year filter on 2021 it shifts to zero, but with the set analysis identifier 1 it should ignore filters