This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(108.80000000000001, 78%, 20%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ET%3C/text%3E%3C/svg%3E)
I have an SQL statement like this:
if @stopDate is null
begin
set @stopDate=dateadd(day,-1,convert(date,getdate()))
set @startDate=dateadd(day,1,dateadd(month,-1,@stopDate))
end
How can I convert this to KQL? I can set one variable fine, but I'm not sure how to do two.
Hi @Maxim Sergeev ,
I have tried iff but I am not sure how to set multiple variables. As an example:
In SQL:
if true
begin
set x = 5
set y = 5
end
In KQL I would do something like:
iff(true, x = 5 and y = 5, "")
But I'm not sure how to set the two variables in one statement.
Use let for the variables, as an example below
let start_time=startofday(ago(24h));
let end_time=startofday(now());
let serviceName = "Custom Service";
let AVAILsla = 90;
let hbav=Heartbeat
| where TimeGenerated > start_time and TimeGenerated < end_time
| summarize heartbeat_per_hour=count() by bin_at(TimeGenerated, 1h, start_time), Computer
| extend available_per_hour=iff(heartbeat_per_hour > 0, true, false)
| summarize total_available_hours=countif(available_per_hour == true) by Computer
| extend total_number_of_buckets=round((end_time - start_time) / 1h)
| extend availability_rate=total_available_hours * 100 / total_number_of_buckets
| order by availability_rate desc;
hbav
| summarize
Name = serviceName,
avg(availability_rate),
availabilitySLA = iif(avg(availability_rate) < AVAILsla, "Bad", "Good"),
ComputerList = makeset(Computer),
dcount(Computer)
| extend SLAobjectiveMet = iif(availabilitySLA == "Good" , "SLA ok", "SLA Not Ok")
| extend HealthState = iif (availabilitySLA == "Good", "✔️", "⚠️")
| project serviceName, SLAobjectiveMet, HealthState
Hi @Tyler ,
Thank you for posting query in Microsoft Q&A Platform.
You can consider writing code as below in this case.
let stopDate = iif(testBool, dateadd(...), <something else>);
let startDate = iif(testBool, dateadd(...), <something else>);
Hope this helps. Please let me know if any further queries.
-------------
Please consider hitting Accept Answer button. Accepted answers help community as well.
Hi @Tyler ,
Just checking in to see if the above answer helped. If this answers your query, do click 
and upvote 
for the same. And, if you have any further query do let us know.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(80, 82%, 17%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EU%3C/text%3E%3C/svg%3E)
Hello,
You can use one of the following:
datatable(name:string, Category:string, Age:int)["Alice", "Reader", 30,
"John","Reader", 10 ,
"Bob","Author", 70
]
// two values
| extend AgeCategory = iif(Age > 18, "Adulte","Child")
| extend HasDrivingLicense = iif(Age > 18, true, false)
// multi set
| extend bag = iif(Age > 18,
bag_pack("Independant", true, "AgeCategory", "Adulte", "HasDrivingLicense", true),
bag_pack("Independant", false, "AgeCategory", "Child", "HasDrivingLicense", false)
)
| evaluate bag_unpack(bag) : (Independant:bool, AgeCategory:string, HasDrivingLicense:bool)