topic Re: Same expression in KPI not working in QlikView

Same expression in KPI not working

gauravgg — Wed, 15 Nov 2017 04:54:56 GMT

Hi all

I have the following expression in Table

(Max(aggr(sum(PRICE_MAT_New),MATERIAL,PLANT,VENDOR,PRICE_MAT_New))

Min(aggr(sum(PRICE_MAT_New),MATERIAL,PLANT,VENDOR,PRICE_MAT_New))

)

FirstSortedValue(VOLUME,

-aggr(sum(VOLUME),MATERIAL,VENDOR,PRICE_MAT_New)

)

When i export the table in excel and sum the calculated column it comes around 66 cr

But the same expression when i put in KPI object it shows some different value

In KPI also it should show 66 cr.

Can anyone help me in this?

Thanks in advance

tresB — Wed, 15 Nov 2017 04:58:22 GMT

Try using an aggregation on your expression, like:

Sum( Aggr( <YourExpression> , <Dimension in chart>))

gauravgg — Wed, 15 Nov 2017 05:07:38 GMT

hi Tresesco ,

I tried ,but there might be some syntax error.

Can you help me in converting the expression into aggr

tresB — Wed, 15 Nov 2017 05:09:16 GMT

Please share your sample app.

mdmukramali — Wed, 15 Nov 2017 06:06:02 GMT

Hi,

What is the output you are getting when you are using only below expression in the KPI.

FirstSortedValue(VOLUME,

-aggr(sum(VOLUME),MATERIAL,VENDOR,PRICE_MAT_New))