Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

Through Time Comparison Counter

I am trying to work on a set analysis that counts the number of Employees who had a decreased number in sales from the previous quarter but I am having trouble figuring out how to go about doing this.

So far I have:

sum({$<[Pd_End_Dt]={"*"},Employee_Name={"*"}>}[Sales])-above(sum({$<[Pd_End_Dt]={"*"},Employee_Name={"*"}>}[Sales]))

but am unable to get past this. I've tried the count function but can't seem to get it to work. Ultimately I would like to be able to drill down from Company>Department>Employee but for right now just need the number of employees that decreased.

The table looks something like this:

   

Pd_End_DtEmployee_NameSales
3/31/2015A300
6/30/2015A350
9/30/2015A200
3/31/2015B150
6/30/2015B200
9/30/2015B200
3/31/2015C500
6/30/2015C400
9/30/2015C300

Any help would be appreciated, thank you!

2 Replies
MVP
MVP

Re: Through Time Comparison Counter

Is this calculated each period (in a straight table?) or for the most recent period (in a text box object)?

Not applicable

Re: Through Time Comparison Counter

I need it to be calculated for each period. The data is updated every month and pulls the last 13 months from a sql table.

Community Browser