Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

Percentage of DISTINCT COL1 having SUM(COL2) < COL3

Hi, community!

I'm having some throuble finding a solution for this. I have a set of data who shows the effort (hours) appointed untill now (GASTOS) per RAT, and I'm trying to find the percentage of DISTINCT RATs (summing the GASTOS column) that are above the estimated effort (ORCADO). The logic behind this is as follows:

qlik.png

Can anyone help me with this?

Thanks a lot!

gbpadial.

1 Solution

Accepted Solutions

Re: Percentage of DISTINCT COL1 having SUM(COL2) < COL3

May be this:

Count({<RAT = {"=Sum(GASTOS) <= ORCADO"}>} DISTINCT RAT)/Count(DISTINCT RAT)

2 Replies

Re: Percentage of DISTINCT COL1 having SUM(COL2) < COL3

May be this:

Count({<RAT = {"=Sum(GASTOS) <= ORCADO"}>} DISTINCT RAT)/Count(DISTINCT RAT)

Not applicable

Re: Percentage of DISTINCT COL1 having SUM(COL2) < COL3

Thanks, Sunny!

It worked like a charm!

Community Browser