Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Support Case Portal will move to Qlik Community Oct 4. Temporary case outage Oct 3. READ DETAILS
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