topic Set Analysis - Sum with date range in QlikView

Set Analysis - Sum with date range

Anonymous — Wed, 11 Jan 2017 17:07:56 GMT

Hi All,

I am pretty new using set analysis and I would like a help from you to solve it.

I have 3 fields and 1 variable. They are: Planned_Qtt, Received_Qtt, Follow_up_date (the fields) and vFollow_up_date (the variable).

What I want is to set the date and the variable and return the value (Planned_Qtt-Received_Qtt)/(Planned_Qtt).

For that I used the formula below, but it doesnt work:

=SUM(IF(vData_Fup>=data_fup,QTDE_PLANEJADA-QTDE_ENTREGUE,0))/sum(QTDE_PLANEJADA)

Does anyone know how to get the value using another expression?

Thaks in advance!

Regards,

sunny_talwar — Wed, 11 Jan 2017 17:17:55 GMT

Would you be able to share a sample of your app with the expected output you would want to see?

satheshreddy — Fri, 27 Jan 2017 06:45:00 GMT

Hi Daniel,

in your EXP

vData_Fup>=data_fup you had mentioned like this but we need to mention single quotation for data.

like below

vData_Fup>='data_fup'

Try the below Exp

=SUM(IF(vData_Fup>='data_fup',QTDE_PLANEJADA-QTDE_ENTREGUE,0))/sum(QTDE_PLANEJADA)

Regards

Sathish