Formula in inline-load

[Danri94]

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 🙂

[maxgro]

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/precedi...

T:

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"]

;

[marcus_sommer · Accepted solution]

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)'];

[Danri94]

That works, thanks a lot!