0 Replies Latest reply: Nov 17, 2016 4:44 PM by Brian Heilig RSS

    Measure interpreted as days in one chart and hours in another

    Brian Heilig

      I am new to Qlik, so thank you in advance for the help.

       

      I have a master measure which looks like this "AVG(DateTime2 - DateTime1)". The DateTime was imported from a .csv file as text. It looks like this: "2016-06-15 05:57:32.0000000".

       

      In one chart the measure looks like it is a result in days, while in another chart the same measure looks like a result in hours (days / 24). What do I need to do to get a consistent result?