Solved: Re: Sum With Particular Products - Qlik Community

Report Inappropriate Content · ‎2015-06-08

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

PrashantSangle · ‎2015-06-08

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

Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

View solution in original post

PrashantSangle · ‎2015-06-08

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

Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

ankit777 · ‎2015-06-08

You can use pick match

PrashantSangle · ‎2015-06-08

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

Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

Kushal_Chawda · ‎2015-06-08

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)