Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

cancel
Showing results for 
Search instead for 
Did you mean: 
MattReinders
Contributor II
Contributor II

Error in set modifier expression

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

1 Solution

Accepted Solutions
amit_saini
Master III
Master III

Hi,

Like this???

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

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

'$#,##0')

Regards,

AS

 

View solution in original post

5 Replies
sunny_talwar

What is PCard.Purchases? Is it a field?
amit_saini
Master III
Master III

Hi,

Like this???

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

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

'$#,##0')

Regards,

AS

 

View solution in original post

MattReinders
Contributor II
Contributor II
Author

Yes PCard.Purchases is a field
MattReinders
Contributor II
Contributor II
Author

Amit, thank you!
amit_saini
Master III
Master III

Your Welcome!

Regards,

AS