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: 
dominikkeller
Contributor III
Contributor III

Error in set modifier ad hoc element list with num

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.

Bildschirmfoto 2019-05-24 um 17.04.10.png

 

Any ideas how to solve it?

1 Reply
zhadrakas
Specialist II
Specialist II

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)))
, '##,#%')