Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Leverage your QlikView investment to modernize BI – see how! Join Group
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator III
Creator III

SUM with SubField in SetExpression

Hello all,

Why is this expression wrong?

=NUM(SUM( {$<TextG1 = {"=subfield(Concat(distinct TextG1,','),',',1)"} , JAHR={'2017'}>} SALDO),'#.###,##'))

Thanks in advance!

1 Solution

Accepted Solutions
Highlighted
MVP & Luminary
MVP & Luminary

Re: SUM with SubField in SetExpression

Try this:

SUM( {$<TextG1 = {'$(=subfield(Concat(distinct TextG1,','),',',1))'} , JAHR={'2017'}>} SALDO)

- Marcus

View solution in original post

2 Replies
Highlighted
MVP & Luminary
MVP & Luminary

Re: SUM with SubField in SetExpression

Try this:

SUM( {$<TextG1 = {'$(=subfield(Concat(distinct TextG1,','),',',1))'} , JAHR={'2017'}>} SALDO)

- Marcus

View solution in original post

Highlighted
Creator III
Creator III

Re: SUM with SubField in SetExpression

Thank you very much Marcus!

Regards,
Gf