Discussion board where members can get started with Qlik Sense.
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:
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:
Any help would be appreciated, thank you!
Is this calculated each period (in a straight table?) or for the most recent period (in a text box object)?
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.