i have some racing times display like 01:31.332(format: mm:ss.fff) and i have a dimension with lap numbers. but when i try to plot these numbers in a chart is keeps on saying that no data could be displayed.
When i plot these numbers in a table with number set to interval, is keep giving me a date and nog the time of a lap.
Having a personal license should not cause any problems related to your question.
- What is the expression you are currently using in your chart?
- How are the racing times stored in your source system?
Currently I can only make assumptions, but my guess is there is a difference between your source and the way Qlik handles date+time and a mistake in your expression (like only asking for a field without a function).
Let me know and we'll see how we can help you from there .
If the same data is in a MySQL DB and exported to an XML file, I would go straight to the database as this saves you having to do the exporting to XML step in the future.
Do you store lap durations or timestamps?
How QlikView stores dates and time is as a number.
42086.000 = March 23, 2015, 0h00
42086.250 = March 25, 2015, 6h00
If date+time is stored in the same way in your MySQL DB, that would make life easy. If not, you have some conversion to do (and than I hope someone else jumps into this topic as I don't fool around with that too often).
If you work with timestamps and you are using the lap number as dimension, you could do something like this: