Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Coming your way, the Qlik Data Revolution Virtual Summit. October 27-29. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator
Creator

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
Highlighted
Partner
Partner

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)

Highlighted
Creator
Creator

Hi Omar,

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

could I use this for each line?

Highlighted
Creator
Creator

if I use sum()/sum()

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

but not in total

Highlighted
Champion
Champion

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