Binary-loaded analysis: expressions behave differently

nubibaseMaincor — Thu, 12 Jun 2025 07:47:33 GMT

Hello,

we are using a binary load for one of our QlikView analyses.
The following expression works in the base analysis, but not in the binary-loaded analysis:

=sum({<
AuftragsMonatZahl -=,
/*DispoLieferMonatZahl= {'>=1<$(=num(month(today())))'},*/
AuftragsMonat -=,
DispoLieferJahr = {'$(=year(today()))'},
Auftragsart = {'Auftragsbestand'},
AuftragsJahr -=,
AuftragsJahrMonat -=,
DispoLieferMonat -=,
DispoLieferdatumJahrMonat -=
>} AuftragWarenwertNettoOffen)

I've identified that the main issue is related to the field 'DispoLieferMonatZahl'.
As soon as I comment out this part of the formula — as shown above — the expression returns a value. Otherwise, the result is always 0.

The values in DispoLieferMonatZahl appear as 1,2,3,4 etc., just like in the original analysis where the formula works correctly.
So I believe the format is correct?

Do you have any ideas or suggestions for resolving this?

Thank you very much!

Regina

Re: Binary-loaded analysis: expressions behave differently

marcus_sommer — Thu, 12 Jun 2025 08:49:52 GMT

The syntax isn't quite right respectively outdated - try a change to:

DispoLieferMonatZahl= {">=1<$(=num(month(today())))"}

Further apply a check if any fix values are working, maybe:

DispoLieferMonatZahl= {1,2,3} and/or DispoLieferMonatZahl= {">=1"}

topic Binary-loaded analysis: expressions behave differently in QlikView

Binary-loaded analysis: expressions behave differently

Re: Binary-loaded analysis: expressions behave differently