Discussion Board for collaboration related to Creating Analytics for QlikView.
From the Google Analytics API I get total visits and total time on site. When I divide the total time on site by total visits I expect the average time on site.
But, and here is the question, the total time is: 1.014374E7. This number supposed to be the total seconds. But when I make an expression timeOnSite / visits it doesn't work.
I have already tried to format it into: interval(num#(metric_timeOnSite, '#.#' ,'.',',')/(24*60*60),'h:mm:ss'), but that gives me null.
Any thoughts on this? Thanks in advance.
Go to Solution.
please take care of the decimal point format and thousand separator. Again, I think the initial load used the wrong settings.
I fixed this with a num#() function, but I would prefer to handle this with standard format settings.
Then you can evaluate your timeOnSite to get the scientific notation correctly in.
Please see also attached.
Did you tried with this?
If it didn't works then try with this.
Hope it helps
Thanks for your reply. Unfortunately both of them don't work.
Find attached the sample document, with the values in it.
Thank you very much Stefan.
You helped me out!