Hi,new here and doubting if this is the right place. but i'll ask nevertheless, and please point me where I should be if it is.I use qlik sense deskto...
new here and doubting if this is the right place. but i'll ask nevertheless, and please point me where I should be if it is.
I use qlik sense desktop, and I would like to make a simple master item.
1) aantal bezoeken: Count(ClientID) = total number of visits
2) totale reistijd: Sum(ReistijdMinuten) = total time of travel in minutes
I want to calculate the average travel time in minutes by dividing total traveltime / number of visits.
I created a master item called : gem_reistijd_per_client:
I get the right answer but it's rounded to a whole number
So as in the example image,
1019 Minutes / 328 visits = 3,11 minutes.
it doesn't have to be in seconds, but not rounded to a whole number.
who can help me fix this ?