Qlik Community

Ask a Question

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Talk to Experts Tuesday, January 26th at 10AM EST: Qlik Sense. REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Specialist II
Specialist II

Calculation in a Text Object

Good morning everyone,

I am trying to create a text object which has a description of my number 1 job opening and the number of open requisitions for that job.  I currently have a TOP 10 open requisitions by job.  I'm using a calculated dimension to get it.  Here's the calculation I use for the dimension :  =if(aggr(Rank(Count(Distinct(Requisition)),SF_Job) <= 10, SF_Job)

and the expression is : Count(Distinct(Requistions)).

I would like a text object which show me SF_Job and number of Requisitions for that job.

Thanks

Labels (1)
1 Solution

Accepted Solutions
MVP
MVP

Try like:

SF_Job = FirstSortedValue(SF_Job, - Aggr(Count(Distinct(Requistions)), SF_Job))

Number of Requisitions = Max(Aggr(Count(Distinct(Requistions)), SF_Job))

View solution in original post

5 Replies
MVP
MVP

Try like:

SF_Job = FirstSortedValue(SF_Job, - Aggr(Count(Distinct(Requistions)), SF_Job))

Number of Requisitions = Max(Aggr(Count(Distinct(Requistions)), SF_Job))

View solution in original post

Specialist II
Specialist II

The count gives me 0, and the Job gives me nulls

Specialist II
Specialist II

=Max(aggr(Count(DISTINCT([Requisition])),[SF_Job]) )  This statement gave me the correct count, just needed a little tuning (Thanks).

Can you please create sample data set and explain your need?
Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
Specialist II
Specialist II

Here is some test data