Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Specialist
Specialist

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

Highlighted
Specialist
Specialist

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

Highlighted
Specialist
Specialist

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

Highlighted

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)
Highlighted
Specialist
Specialist

Here is some test data