Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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"}