topic Re: Formula in inline-load in App Development

Formula in inline-load

Danri94 — Thu, 02 Nov 2023 08:22:46 GMT

Hi everybody,

im an trying to use a Field (Monatsbeginn) in my inline-load, i have created in the load-Statement above.

Can anybody help me?

LOAD *,
date(monthstart(today())-1) as Monatsbeginn
INLINE [
ID, Text_DE, Text_EN
1, Deckungsbeitrag operativ zum "Monatsbeginn", profit margin operational at the "Monatsbeginn"]

As a result i want to use the calculated date in my translation.

Thank you 🙂

Re: Formula in inline-load

maxgro — Thu, 02 Nov 2023 11:28:57 GMT

if I understand the question, you can use a preceding load in the script

https://help.qlik.com/en-US/qlikview/May2023/Subsystems/Client/Content/QV_QlikView/Scripting/preceding-load.htm

LOAD

DATE(Monatsbeginn + 1) AS NewField // example of using the calculated date

;

LOAD *, date(monthstart(today())-1) as Monatsbeginn INLINE [

ID, Text_DE, Text_EN

1, Deckungsbeitrag operativ zum "Monatsbeginn", profit margin operational at the "Monatsbeginn"]

;

Re: Formula in inline-load

marcus_sommer — Thu, 02 Nov 2023 12:56:49 GMT

I think you may try it in this way:

LET var = date(monthstart(today())-1);

LOAD * INLINE [
ID, Text_DE, Text_EN
1, Deckungsbeitrag operativ zum '$(var)', profit margin operational at the '$(var)'];

Re: Formula in inline-load

Danri94 — Thu, 02 Nov 2023 13:48:34 GMT

That works, thanks a lot!