topic Re: Using if statements in data load in App Development

Using if statements in data load

DanielSchneider — Thu, 20 Jun 2019 13:34:19 GMT

Hello,

I am having trouble getting used to the syntax in QlikSense (used to matlab). I am trying to have another column loaded into my data so I can create a line chart using both the Test and the Week as variables on the x axis.

Here is where I am having trouble:

LOAD
    LogDate,
    Date(LogDate,'MM/DD/YYYY') as calDate,
    WeekDay(LogDate) as Day,
    Week(LogDate) as Week,
    Hour(LogDate) as HourW1
    Hour(LogDate)-168*Week) as HourW2
    IF (Week=1,HourW1,Hour=Hour(LogDate)-168*Week)
    then
     <Hour=Hour(LogDate)>
    else
    < Hour=Hour(LogDate)-168*Week>
    IF(Hour=>0 && Hour<54)
    Test=ClgMaxLoad1
    Elseif(Hour=>54 && Hour<90)
    Test=HeatingFlood
    Elseif(Hour=>90 && Hour<126)
    Test=ClgMaxLoad2
    Elseif(Hour=>126 && Hour<162)
    Test=ODFanFail
    Elseif(Hour=>162)
    Test=OFF

Any help is appreciated,

Daniel

Re: Using if statements in data load

sunny_talwar — Thu, 20 Jun 2019 14:11:45 GMT

Can you put in words what your condition is doing?

Re: Using if statements in data load

DanielSchneider — Thu, 20 Jun 2019 14:15:19 GMT

Hi Sunny,

Our testing runs the same week long program for one week, with different tests running for specified hours.

The condition first converts the loaded date into hours, checks if it is after week one ( subtracts hours until it is in the same week long format), then outputs the test according to what hour it is on.

Hopefully that is descriptive enough.

Daniel