topic Re: Calculation in a Text Object in QlikView

Calculation in a Text Object

tmumaw — Sat, 16 Nov 2024 02:54:05 GMT

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

Re: Calculation in a Text Object

tresB — Fri, 26 Jul 2019 12:20:53 GMT

Try like:

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

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

Re: Calculation in a Text Object

tmumaw — Fri, 26 Jul 2019 12:31:12 GMT

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

Re: Calculation in a Text Object

tmumaw — Fri, 26 Jul 2019 12:39:25 GMT

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

Re: Calculation in a Text Object

Anil_Babu_Samineni — Fri, 26 Jul 2019 12:40:26 GMT

Can you please create sample data set and explain your need?

Re: Calculation in a Text Object

tmumaw — Fri, 26 Jul 2019 12:55:59 GMT

Here is some test data