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.
paulyeo11
Valued Contributor II

How to add COUNTRY_={"Singapore"} & COUNTRY_={"CASH SALES"} ?

Hi All

I have 2 expression both are okay :-

Sum({$<year = {$(=Max(year)-0)}, month = {"<=$(=Max({<year={$(=Max(year))}, sales = >} month))"},COUNTRY_={"Singapore"}>}sales/Rate)

Sum({$<year = {$(=Max(year)-0)}, month = {"<=$(=Max({<year={$(=Max(year))}, sales = >} month))"},COUNTRY_={"CASH SALES"}>}sales/Rate)

I like to conbine them into 1 expression , but cannot work :-

Sum({$<year = {$(=Max(year)-0)}, month = {"<=$(=Max({<year={$(=Max(year))}, sales = >} month))"},COUNTRY_={"CASH SALES"}+COUNTRY_={"Singapore"}>}sales/Rate)

Can some one advise me.

Paul

1 Solution

Accepted Solutions
antoniotiman
Honored Contributor III

Re: How to add COUNTRY_={"Singapore"} & COUNTRY_={"CASH SALES"} ?

......,COUNTRY_={[CASH SALES],'Singapore'} .....

Regards,

Antonio

3 Replies
paulyeo11
Valued Contributor II

Re: How to add COUNTRY_={"Singapore"} & COUNTRY_={"CASH SALES"} ?

my qvw

antoniotiman
Honored Contributor III

Re: How to add COUNTRY_={"Singapore"} & COUNTRY_={"CASH SALES"} ?

......,COUNTRY_={[CASH SALES],'Singapore'} .....

Regards,

Antonio

paulyeo11
Valued Contributor II

Re: How to add COUNTRY_={"Singapore"} & COUNTRY_={"CASH SALES"} ?

Thank you sir

Community Browser