Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Connect 2026! Turn data into bold moves, April 13 -15: Learn More!
cancel
Showing results for 
Search instead for 
Did you mean: 
nubibaseMaincor
Contributor
Contributor

Binary-loaded analysis: expressions behave differently

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

Labels (1)
1 Reply
marcus_sommer

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