topic Re: Error in set modifier expression in QlikView

Error in set modifier expression

MattReinders — Wed, 05 Dec 2018 00:24:47 GMT

Hello All,

Look for some help here as I am running into a Error in Set Modifier Expression. Here is the expression:

=num(sum({<[PCard.Purchases] - Sum({<Description={'TD'},[Card Bank]={'US Bank'}>}[Amount USD])),'$#,##0')

The goal is to subtract ({<Description={'TD'},[Card Bank]={'US Bank'}>}[Amount USD]) from [Pcard.Purchases]

Really appreciate the help.

Matt

sunny_talwar — Wed, 05 Dec 2018 01:42:23 GMT

What is PCard.Purchases? Is it a field?

amit_saini — Wed, 05 Dec 2018 10:49:28 GMT

Hi,

Like this???

=num(sum([PCard.Purchases]) -

Sum({<Description={'TD'},[Card Bank]={'US Bank'}>}[Amount USD])
,

'$#,##0')

Regards,

MattReinders — Wed, 05 Dec 2018 17:08:47 GMT

Yes PCard.Purchases is a field

MattReinders — Wed, 05 Dec 2018 17:10:37 GMT

Amit, thank you!

amit_saini — Thu, 06 Dec 2018 18:28:16 GMT

Your Welcome!

Regards,