Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
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
sunny_talwar

May be this:

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

View solution in original post

2 Replies
sunny_talwar

May be this:

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

View solution in original post

Not applicable
Author

Thanks, Sunny!

It worked like a charm!