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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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"}