Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

In my Expression, sum( {1 < Flag = {1}> }AMT*FREQ), I want to add one more condition, Where Sales Id is distinct. How to add this condition in my expression...

In my Expression, sum( {1 < Flag = {1}> }AMT*FREQ), I want to add one more condition, Where Sales Id is distinct. How to add this condition in my expression...

Thanks in Advance

Siddharth

Tags (2)
2 Replies
jyothish8807
Honored Contributor II

Re: In my Expression, sum( {1 < Flag = {1}> }AMT*FREQ), I want to add one more condition, Where Sales Id is distinct. How to add this condition in my expression...

Hi Sidd,

Try like this:

aggr(distinct sum( {1 < Flag = {1}> } AMT*FREQ),Sales ID)

Regards

KC

Best Regards,
KC

Re: In my Expression, sum( {1 < Flag = {1}> }AMT*FREQ), I want to add one more condition, Where Sales Id is distinct. How to add this condition in my expression...

Not sure what you are looking for, but may be this:

Sum({1<Flag = {1}, [Sales Id] = {"=Count([Sales Id]) = 1"}>} AMT*FREQ)

Community Browser