topic Re: Question about expression in QlikView

Question about expression

sergioskv — Wed, 24 Apr 2019 10:41:49 GMT

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()...

Re: Question about expression

arpitkharkia — Wed, 24 Apr 2019 10:51:02 GMT

Create a flag like

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

Use this flag in your expressions accordingly.

Regards,

Arpit

Re: Question about expression

sunny_talwar — Wed, 24 Apr 2019 11:04:19 GMT

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)

Re: Question about expression

sergioskv — Wed, 24 Apr 2019 11:05:28 GMT

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.

Re: Question about expression

sunny_talwar — Wed, 24 Apr 2019 11:10:03 GMT

Another way could be this

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

Re: Question about expression

sergioskv — Wed, 24 Apr 2019 11:12:07 GMT

Thanks!

This example is first what i already tried.

But it doesn't work.

Re: Question about expression

sergioskv — Wed, 24 Apr 2019 11:12:45 GMT

I think i need P() here? Yes?

Re: Question about expression

sunny_talwar — Wed, 24 Apr 2019 11:16:47 GMT

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