topic regarding or condition in QlikView

regarding or condition

Fri, 02 May 2014 11:08:39 GMT

hi team, i have a doubt .

customer name sales sales

abc 2000 25000

xyz 3000 4000

lmn 2500 5000

i want sum of sales when customer abc or ayz

Gysbert_Wassenaar — Fri, 02 May 2014 11:46:07 GMT

sum({<[customer name] = {'abc','ayz'}>}sales)

If you mean xyz instead of ayz, then replace ayz with xyz in the expression above.

MK_QSL — Fri, 02 May 2014 11:49:10 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)

its_anandrjs — Fri, 02 May 2014 12:15:14 GMT

Simply write

Sum({< [customer name] = {'abc','xyz'} >} sales)

but your question is for customer abc or ayz

replace ayz to xyz in the table.

Fri, 02 May 2014 12:16:59 GMT

HI IF I USE AND CONDITION INCASE OF OR CONDITION ITS SHOWING NO VALUE

its_anandrjs — Fri, 02 May 2014 12:21:30 GMT

Then write like below script because you want only abc, xyz then ignore lmn

Sum({< [customer name] -= {'lmn'} >} sales)