creating the (calculated)measure for visual --problem

[Anonymous]

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

but I did not get anything

any one can help?

Thank you

[OmarBenSalem]

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)

[Anonymous]

Hi Omar,

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

could I use this for each line?

[Anonymous]

if I use sum()/sum()

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

but not in total

[YoussefBelloum]

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