Qlik Community

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
Now Live: Qlik Sense SaaS Simplified Authoring – Analytics Creation for Everyone: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
jerryr125
Educator-Ambassador
Educator-Ambassador

Question about Sum expression - filtering by date

HI - I have the following expression in a table chart:

Sum({$<[materialid]={'mat01'}, [areaid]={'A15'}, [matnumber]={'90125'}>} FABS(transactionquantity))

Works perfectly...

But when I add a filter to only include transaction dates on or after 06/10/2021 I receive an error.

Sum({$<[materialid]={'mat01'}, [areaid]={'A15'}, [matnumber]={'90125'}, [transactiondate.autoCalendar.Date]>{'06/10/2021'}>}FABS(transactionquantity))

 

Any thoughts how I can accomplish the above ?

Thanks -

Jerry

 

 

1 Solution

Accepted Solutions
AshutoshBhumkar
Partner - Specialist
Partner - Specialist

Hello,

Try below expression 

Sum({$<[materialid]={'mat01'}, [areaid]={'A15'}, [matnumber]={'90125'}, 

[transactiondate.autoCalendar.Date]={">=06/10/2021"}>}FABS(transactionquantity))

 

 

View solution in original post

2 Replies
AshutoshBhumkar
Partner - Specialist
Partner - Specialist

Hello,

Try below expression 

Sum({$<[materialid]={'mat01'}, [areaid]={'A15'}, [matnumber]={'90125'}, 

[transactiondate.autoCalendar.Date]={">=06/10/2021"}>}FABS(transactionquantity))

 

 

eliran
Creator III
Creator III

Hi,

This part is wrong -[transactiondate.autoCalendar.Date]>{'06/10/2021'}

You need to alter it as follows

[transactiondate.autoCalendar.Date]={'>06/10/2021'}

 

BR,

Eliran