topic Sum With Particular Products in QlikView

Sum With Particular Products

Mon, 08 Jun 2015 11:50:29 GMT

Hi Experts

I am Using a Pivot Table

in that I want to sum the sales for particular [Product code] ones only,

How can I do it

Currently i used this but not yielding any results

sum(if([Product Code]= '155','156','157',158','159','160','161','162','163','164','165','166','167','168','169','170','171','172','173','174','176', Sales))

Please Suggest

Re: Sum With Particular Products

PrashantSangle — Mon, 08 Jun 2015 11:52:35 GMT

Try

sum(if(Wildmatch([Product Code], '155','156','157',158','159','160','161','162','163','164','165','166','167','168','169','170','171','172','173','174','176'), Sales))

regards

Re: Sum With Particular Products

ankit777 — Mon, 08 Jun 2015 11:52:51 GMT

You can use pick match

Re: Sum With Particular Products

PrashantSangle — Mon, 08 Jun 2015 11:53:53 GMT

Hi,

Or you can try in set analysis like

sum({<[Product Code]={'155','156','157',158','159','160','161','162','163','164','165','166','167','168','169','170','171','172','173','174','176'}>}Sales)

Regards

Re: Sum With Particular Products

Kushal_Chawda — Mon, 08 Jun 2015 12:08:46 GMT

try to use set analysis

sum({<[Product Code]= {'155','156','157',158','159','160','161','162','163','164','165','166','167','168','169','170','171','172','173','174','176'}>}Sales)