Equivalent of oracle expression

[Anonymous]

Hi

Is the below expression is equivalent to the oracle expression?

(count(jobid)/(sum(count(jobid) over (partition by pending_category)))*100 - Oracle

Count(JOBID)/(sum(Count(JOBID),PENDING_CATEGORY)) - Qlikview with Number format %

Some how i dont get the values correct with the above expression , please correct me if am wrong.

[disqr_rm]

I think you are looking to use aggr() function together with sum. Search for AGGR() and you should see lot of useful examples you can use in your expression.

Rakesh

[Anonymous]

first thing i used is , is there something wrong in this expression?

Count (JOBID)/aggr(Count(JOBID,PENDING_CATEGORY))

[disqr_rm]

Where do you have this expression? In a chart? What's you dimension?

Possible to post a sample app with little data?

In first look, I can see you missed the placement of dimension for aggr function. This may work:

Count (JOBID)/aggr(Count(JOBID),PENDING_CATEGORY)

But again, if this doesn't work, place a sample app with details of what you are trying to achieve.

Rkaesh

[Anonymous]

Attached is the sample app, i want % of Jobs By pend Category.

Thanks!

[disqr_rm]

Try this one:

=Count (DISTINCT JOB_ID)/ aggr(NODISTINCT Count(DISTINCT JOB_ID), PENDING_CATEGORY)