topic Re: regarding or condition in QlikView

regarding or condition

Fri, 02 May 2014 11:14:15 GMT

DEAR TEAM I HAVE ONE DOUBT PLEASE FIND BELOW

YEAR1 YEAR2

customer name sales sales

ABC 2000 25000

XYZ 3000 4000

LMN 5000 6000

FROM THIS I WANT SUM OF SALES WHEN CUSTOMER IS ABC OR XYZ

Re: regarding or condition

swuehl — Fri, 02 May 2014 11:15:34 GMT

sum({<[customer name] = {'ABC', 'XYZ'}>} SALES)

Re: regarding or condition

anbu1984 — Fri, 02 May 2014 11:17:28 GMT

Sum(If([Customer name] = 'ABC' Or [Customer name] = 'XYZ',Sales))

Re: regarding or condition

Fri, 02 May 2014 11:42:09 GMT

thanks its working

Re: regarding or condition

MK_QSL — Fri, 02 May 2014 11:44:55 GMT

Use below in script

===============

CrossTable(Year, Sales)

Load * Inline

[

customer name, YEAR1 sales, YEAR2 sales

ABC, 2000, 25000

XYZ, 3000, 4000

LMN, 5000, 6000

];

=====================

Use below in text box (Same as suggested by Stefan)

=SUM({<[customer name] = {'ABC','XYZ'}>}Sales)

Re: regarding or condition

anbu1984 — Fri, 02 May 2014 12:01:15 GMT

Can you mark posts Anwered/Helpful?

Re: regarding or condition

ThornOfCrowns — Fri, 02 May 2014 12:04:27 GMT

Please make sure you reply to both of your threads, this one and http://community.qlik.com/thread/116940 to make sure that everything ties up neatly.

Also, in future could you please try to not re-ask the same question in different threads?

Regards,

James.

Re: regarding or condition

Fri, 02 May 2014 12:15:43 GMT

HI HOW TO USE AND CONDITION OF THIS INCASE OF OR

Re: regarding or condition

anbu1984 — Fri, 02 May 2014 12:29:16 GMT

Replace Or by And

Sum(If(Field1 = 'ABC' And Field2 = 'XYZ',Sales))

Re: regarding or condition

anbu1984 — Fri, 02 May 2014 12:44:32 GMT

Do you mean you want to use And in this condition "[Customer name] = 'ABC' Or [Customer name] = 'XYZ'"?