topic Re: if condition help in QlikView

if condition help

suryakant241187 — Wed, 25 Nov 2020 16:16:04 GMT

I have multiple data of employee like

Quata Hours

Legal Last year 3

Legal Leave 2

Overtime 1

but i have to show the hours of Legal Last Year. Please help.

Re: if condition help

arulsettu — Fri, 29 Jul 2016 12:18:44 GMT

try this

count({<Quata={'Legal Last year'}>}Hours)

Re: if condition help

Chanty4u — Fri, 29 Jul 2016 12:21:05 GMT

try below

let vlastyear='Max(year)-1';

count({<Quata={'$(Vlastyear)'}>}Hours)

Re: if condition help

Anonymous — Fri, 29 Jul 2016 12:26:13 GMT

According to your question we can write with if statement and also with set analysis.

if statement:

if(Quata='Legal Last year', sum(Hours),0)

// the reason i took sum is because looks like you wanted to do sum of the hours done by the empolyee. if you want to //how many times he did work use count.

Set Analysis which is the better approach:

sum({<Quata={'Legal Last year'}>}Hours)