Skip to main content
Announcements
Customer Spotlight: Discover what’s possible with embedded analytics Oct. 16 at 10:00 AM ET: REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
sergioskv
Contributor III
Contributor III

Question about expression

Hi community!

I have a question.

Case:

CheckId    Sku     Qty

1                      1         2

1                      2         5

1                      3         7

How can i define Checkid 's that have Qty of every Sku's less than 10???   for example .

I have some problems with P()...

7 Replies
arpitkharkia
Creator III
Creator III

Create a flag like

if(qty>10,1,0) as flag

Use this flag in your expressions accordingly.

Regards,

Arpit

sunny_talwar

Where exactly are you hoping to use this? In a straight table? and if I read this right, you want to pick CheckId where every Sku has a quantity of less than 10. If there is even one Sku where the quantity is greater than 10, you would not pick it, right? May be this for a straight table

Sum({<CheckId = {"=Count(DISTINCT Sku) = Count(DISTINCT {<Qty = {[<10]}>} Sku)"}>} Qty)
sergioskv
Contributor III
Contributor III
Author

Thank u.
This flag will show result for each row. But i don't need like sum({<Flag={0}>} sales).
I need full check sales, if no rows with qty > 10 in this check?, else i don't want to see this check completely.
sunny_talwar

Another way could be this

Sum({<CheckId = e({<Sku = p({<Qunatity = {">10"}>})>})>} Qty)
sergioskv
Contributor III
Contributor III
Author

Thanks!

This example is first what i already tried.

But it doesn't work.

 

sergioskv
Contributor III
Contributor III
Author

I think i need P() here? Yes?

sunny_talwar

Can you share a sample where this isn't working.