topic Re: Set Expression Help in QlikView

Set Expression Help

kakani87 — Tue, 13 Mar 2018 11:28:17 GMT

Hi Folks ...

Here i want to show the Avg Days between collection and Bill days for three months where there is a flag for them

below is the expression i'm trying to achieve the result can some one help me to come out of this issue

avg ( aggr ( Max (

tran_date={"$(=DATE(AddMonths(Max(tran_date),-2),'MMM YYYY'))"}

,fact_type={'COL'}

tran_date

)

Max

(

tran_date={"$(=DATE(AddMonths(Max(tran_date),-2),'MMM YYYY'))"}

,fact_type={'INVD'}

tran_date

)

,sales_pk

))

sunny_talwar — Tue, 13 Mar 2018 11:30:42 GMT

trans_date is in MMM YYYY format?

kakani87 — Tue, 13 Mar 2018 11:48:12 GMT

No Sunny ...

let me show you something i found in back end

convert(numeric,datediff(day,receipt_bill_date , isnull(h.d_chq_dt, h.d_rec_date))) as receipt_age

using these two fields

receipt_bill_date and d_rec_date they calculated Receipt age

but i need to display avg of this in front end as Avg Days

d_rec_date is considered as tran_date

Here in script while fetching h.d_rec_date as tran_date,

kakani87 — Tue, 13 Mar 2018 11:53:48 GMT

This receipt_age field can we display for three months

sunny_talwar — Tue, 13 Mar 2018 12:07:00 GMT

Not able to follow you entirely... is there a sample you can share?

kakani87 — Tue, 13 Mar 2018 12:44:42 GMT

Not Able to share the sample Sunny but some thing based on the back end Calculated field i have considered

so let me check the feedback then i can tell you clearly my issue.

Thank you for the response

sunny_talwar — Tue, 13 Mar 2018 16:28:12 GMT

Sure thing