Using Variable in a calculation

Wed, 05 Jun 2013 23:46:04 GMT

I am trying to calculate system up time in a table in my dashboard. I have created a variable in the load script to determine how many minutes have passed since the beginning of the Fiscal year which starts on 10/1:

Let MinutesThisFY=interval(now()-(YearStart(Now(), 0, 10)),'mm');

My source for this is currently a spreadsheet which has a line for every outage, grouped by system. Which means for any given system, there could be multiple outages to be aggregated. In the spreadsheet it has, among other columsn, a start time column, and end time column, and a column that calculates the difference between the start time and end time in minutes (column is called Minutes).

In a Straight Table object I have the System as the dimension, then as Expressions I have the Total Time, the MinutesThisFY, and the difference between the two in three columns. The first two show up correctly, but the calculation give me very strange results. The calculation I'm using is:

=MinutesThisFY - sum(Minutes)

However, the results I'm seeing are like this:

Sum(Minutes) = 8575

MinutesThisFY = 356663

MinutesThisFY - sum(Minutes) = -8327.31715277777 (Instead of 348088 like I'm expecting)

Can someone help me figure out where I'm going wrong? Thank you!

Re: Using Variable in a calculation

calvindk — Thu, 06 Jun 2013 01:26:43 GMT

Use dollar sign expansion.

$(MinutesThisFY) - sum(Minutes)

Re: Using Variable in a calculation

Thu, 06 Jun 2013 15:29:35 GMT

Doh! Thanks Anders! Figured it had to be something simple. Thanks for your reply!

topic Using Variable in a calculation in QlikView

Using Variable in a calculation

Re: Using Variable in a calculation

Re: Using Variable in a calculation