Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
MK_QSL
MVP
MVP

Set Analysis with WeekNo and Positive Margin

Want to show sale for last 10 weeks….

Where %Profit should be > 0%.

Document Date is the date...

Please help....

4 Replies
MK_QSL
MVP
MVP
Author

What is wrong in below expression?

=SUM({$<Profit = {">0%"}, Week = {"<=$(Week(Today()-7")} >}InvoiceAmount)

Not applicable

Is the field Profit really with a %-sign? Isn't that only a number format?

So maby

=SUM({$<Profit = {">0"}, Week = {"<=$(Week(Today()-7")} >}InvoiceAmount)


MK_QSL
MVP
MVP
Author

I am receiving an error....!!!

sushil353
Master II
Master II

Hi,

What error you are getting?

try the below expression if you are having profit in real number format..

=SUM({$<Profit -= {0}, Week = {"<=$(Week(Today()-7")} >}InvoiceAmount)

HTH

Sushil