Qlik Community

Ask a Question

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Welcome to our newly redesigned Qlik Community! Read our blog to learn about all the new updates: READ BLOG and REPORTED ISSUES
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