topic Calculating %ages from and expressioin in QlikView

Calculating %ages from and expressioin

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hi all,

i have an equation where Sales of shop = (A+b)/C

how can i get the percentage of the sales of each shop using the above equation ?

vishsaggi — Mon, 20 Feb 2017 19:12:30 GMT

Can you share a sample app and expected output you are looking for?

Tue, 21 Feb 2017 04:40:20 GMT

Can u elaborate it more

eromiyasimon — Tue, 21 Feb 2017 04:48:04 GMT

go to number tab and enable the percentage option for that expression

hemanthaanichet — Tue, 21 Feb 2017 04:48:11 GMT

Can you say it little bit clear??

This is my purely guess iam not sure whether is this your requirement

dimension : shop names

expression: ((sum({<fieldname={'A'}>}sales) + sum({<fieldname={'B'}>}sales) )/ sum({<fieldname={'C'}>}sales))*100

jonathandienst — Tue, 21 Feb 2017 05:35:57 GMT

Your requirements are a little vague, but lets assume that you want % sales by shop in a table / chart and A, b, C are fields in your data model:

Use shop (name / code or ID number) as the dimension (lets assume ShopName).

Use the expression

=Sum(Aggr((Sum(A) + Sum(b)) / Sum(C), ShopName)) / Sum(TOTAL Aggr((Sum(A) + Sum(b)) / Sum(C), ShopName))

Adjust the field names to your requirements.

sdmech81 — Tue, 21 Feb 2017 05:46:48 GMT

If everything is well associated then:

Sum(A)+Sum(B)/Sum(C)

A,B,C are ur attributes..