topic Tranform a formula in set analysis in QlikView

Tranform a formula in set analysis

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hi everybody,

I have a text box with this:

=date(Min({$<[délai_Kx_rest_du]={">365"}>} %KeyDate), 'MMM YY')

that gives me the max month used in the chart.

Now I would like to use this formula in a set analysis with date= this formula.

I cannot get any set analysis ok ?

Any suggestion ?

Re: Tranform a formula in set analysis

rubenmarin — Tue, 30 Jan 2018 17:25:18 GMT

Hi Bertrand, you can try creating a variable with that expression, and use the variable value in set analysis:

DateFieldName={'$(variableName)'}

With an input box you can check the variable value. Working with dates can be tricky, maybe you are giving a number when in expects a text or viceversa.

Re: Tranform a formula in set analysis

sunny_talwar — Tue, 30 Jan 2018 18:04:37 GMT

Does it give you max month of min month? I see the usage of Min() function.

Also, %KeyDate is in format MMM YY? or another format?

Re: Tranform a formula in set analysis

shiveshsingh — Wed, 31 Jan 2018 07:46:02 GMT

Is it max or Min?

Re: Tranform a formula in set analysis

Anonymous — Wed, 31 Jan 2018 08:12:18 GMT

Yes that's finally what I did and it works. Thanks a lot.