Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

yangcelinexu
Contributor

creating the (calculated)measure for visual --problem

Hi,

Have being a while did not use the qlik sense

wondering how to create a new measurement to do the visual

I want to divided the 'total sales' by 'total population' and call it 'sales per person'

I use 'Mast item' creating 'measur'' and use this function:

Sub_Volume_Skoda/Population_total

Screen Shot 2018-05-11 at 17.03.55.png

but I did not get anything

any one can help?

Thank you

4 Replies
OmarBenSalem
Esteemed Contributor

Re: creating the (calculated)measure for visual --problem

try:

since it's a measure, u'll have to use aggregation functions to calculate ur measure (sum, count, avg, min,max etc):

sum(measure1) / sum(measure2)

yangcelinexu
Contributor

Re: creating the (calculated)measure for visual --problem

Hi Omar,

thank you. it works but it works as sum()

could I use this for each line?

yangcelinexu
Contributor

Re: creating the (calculated)measure for visual --problem

if I use sum()/sum()

I am expecting have number for each row as Sub_Volume_Skoda/Population_total

but not in total

YoussefBelloum
Esteemed Contributor

Re: creating the (calculated)measure for visual --problem

depending on the object type you're using, you can disable/remove the total line

Community Browser