Error in set modifier ad hoc element list with num

dominikkeller — Fri, 24 May 2019 15:14:17 GMT

Hey Guys,

it's me again. i need your help.

i was building this expression:

=Sum({$<SollWerte18.Bereich={'Soll Kueche'},Geschäftsjahr=,Datum={'$(=date(max(SollWerte18.Datum)'}>}SollWerte18.Data)

-(num((Sum({$<DATUM={'$(=date(max(DATUM)))'},BWA_Bezeichnung={'Wareneinsatz Küche Vorjahr aufgelaufen Prozent'}>}BWA_Wert)),'##,#'))

&' %'

the output is correct, but i can't make it a num format like '##,#'. I tried every scenario for num() but everything i get is an error or a long number.

Any ideas how to solve it?

Re: Error in set modifier ad hoc element list with num

zhadrakas — Mon, 27 May 2019 06:55:39 GMT

try this:
maybe you need to add /100

=num(
Sum({$<SollWerte18.Bereich={'Soll Kueche'},Geschäftsjahr=,Datum={'$(=date(max(SollWerte18.Datum)'}>}SollWerte18.Data)

-((Sum({$<DATUM={'$(=date(max(DATUM)))'},BWA_Bezeichnung={'Wareneinsatz Küche Vorjahr aufgelaufen Prozent'}>}BWA_Wert)))
, '##,#%')

topic Error in set modifier ad hoc element list with num in QlikView

Error in set modifier ad hoc element list with num

Re: Error in set modifier ad hoc element list with num