Solved: Percent Sales for Region - Qlik Community

mhmmd_srf · ‎2017-03-07

Hi All,

I have requirement like below in Qlikview:

The Percent Sum is like Sales for Each Region divided by Sales for all Region.

Please help.

Thanks,

Sarif

MindaugasBacius · ‎2017-03-07

Maybe:

Sum(Sales)/Sum(TOTAL Sales)

View solution in original post

MindaugasBacius · ‎2017-03-07

Maybe:

Sum(Sales)/Sum(TOTAL Sales)

mhmmd_srf · ‎2017-03-07

Hi Bacius,

Is TOTAL a function ?

Please help.

Thanks,

Sarif

PrashantSangle · ‎2017-03-07

Yes.

It gives sum of Sales for all Region

Regards,

Prashant

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 🙂

muthukumar77 · ‎2017-03-07

May be like this,

Sum(total <RGN> Sales)/Sum(TOTAL Sales)

Muthukumar Pandiyan

tresesco · ‎2017-03-07

TOTAL is a qualifier that helps calculation in chart to disregard dimensions. For detailed explanation read it here: Keywords : TOTAL, ALL & DISTINCT

jonathandienst · ‎2017-03-07

Or

Sum(Sales)/Sum(TOTAL <RGN> Sales)

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein