Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Customers, Partners & Luminaries only: You're invited to a Data Analytics Roadmap session. Read More
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Not applicable

Value group by KPI

Hi mates!

I got this table:

    

DATOKPIVAL DATOVAL KPI
D.001D.001.K199,2205%98,4679%
D.001D.001.K199,2205%98,4679%
D.001D.001.K199,2205%98,4679%
D.001D.001.K199,2205%98,4679%
D.001D.001.K299,2205%100,0000%
D.001D.001.K299,2205%100,0000%
D.001D.001.K499,2205%98,9989%
D.001D.001.K499,2205%98,9989%
D.001D.001.K499,2205%98,9989%
D.001D.001.K499,2205%98,9989%
D.001D.001.K599,2205%100,0000%
D.001D.001.K599,2205%100,0000%
D.001D.001.K599,2205%100,0000%
D.001D.001.K699,2205%-
D.001D.001.K699,2205%-
D.001D.001.K699,2205%-
D.001Gar_599,2205%

-

Now I´m getting VAL DATO as the average of all values of VAL KPI (without null values).

I want to get the average of these values by KPI (without null values), the table will be like this:

 

DATOKPIVAL DATOVAL KPI
D.001D.001.K199,3667%98,4679%
D.001D.001.K199,3667%98,4679%
D.001D.001.K199,3667%98,4679%
D.001D.001.K199,3667%98,4679%
D.001D.001.K299,3667%100,0000%
D.001D.001.K299,3667%100,0000%
D.001D.001.K499,3667%98,9989%
D.001D.001.K499,3667%98,9989%
D.001D.001.K499,3667%98,9989%
D.001D.001.K499,3667%98,9989%
D.001D.001.K599,3667%100,0000%
D.001D.001.K599,3667%100,0000%
D.001D.001.K599,3667%100,0000%
D.001D.001.K699,3667%-
D.001D.001.K699,3667%-
D.001D.001.K699,3667%-
D.001Gar_599,3667%-

Thank you very much guys!!

2 Replies
Highlighted
MVP & Luminary
MVP & Luminary

Try avg({<[Val KPI]={">0"}>}total [Val KPI])


talk is cheap, supply exceeds demand
Highlighted
Not applicable

Thank you Gysbert,

Sorry but I'm trying to do it on Script, is it possible?

Thanks again.