topic Re: Conditional calculation in QlikView

Conditional calculation

Wed, 23 Dec 2015 01:13:43 GMT

Hello everybody

I'm just beginning my work in qlik sense and I've been trying to solve a problem but I didn´t succeed so far.

I have a table from a Call center with call dates and blanks (see below)

The dates of calls refer to years 2014 and 2015.

With the function count(year(call pick up )) the output is the total number of calls during 2014 and 2015 and is ok.

The problem is when I want to calculate the number of calls separately by year.

As the year is implicit in the data I tried something like this

if(year(call pick up)=2015,count(call pick up)

or instead

count({$<year(call pick up)={$("2015"}>} year (call pick up))

Can somebody help?

Thks in advance

Joao Pereira

sunny_talwar — Wed, 23 Dec 2015 16:53:48 GMT

Did you try this:

Count(If(Year(call pick up) = 2015, [Call pick up]))

Basically add the if statement within the Count() function

Thu, 24 Dec 2015 00:07:52 GMT

Hello Sunny

Thanks for your prompt response.

It works perfectly

Joao Pereira

sunny_talwar — Thu, 24 Dec 2015 11:32:09 GMT

Great

Just as an suggestion for improvement, you can create Year in script like this may be:

LOAD [call pick up],

Year([call pick up] as Year

FROM Source

and can then use set analysis instead of if statement. Set analysis is much more efficient than if statements

Count({<Year = {2015}>}[call pick up])