topic Time calculation in QlikView

Time calculation

Wed, 03 Aug 2011 22:05:12 GMT

Hi All,

I have a chart which has the amount of RAM used vs time per user. It's a straigh table right now but will be convereted to a bar chart (stacked).

I want to display the times only for today's date in one chart. And in another chart just for todays date, all times between 6AM and 10AM.

I have calculated a function for time, but its not showing any values.

Please help.

Thu, 04 Aug 2011 04:45:27 GMT

Try This:

In Dimension:

if(Floor(sampletime)=today(),time(Sampletime))

Use instead of Today() , a Variable....like

if(floor(Sampletime)= $(variable1),time(sampletime))

in the Script...define Variable as:

Let variable1 = num(now());

Here the variable will contain the Value of the Time when u reload the data.

Don't define now() in frontend as its value changes every sec.