topic Re: Month is not highlighting ? in QlikView

Month is not highlighting ?

Fri, 31 Oct 2014 13:25:38 GMT

HI All,

I have to calculate Balance Amount up to Every Month from Starting on wards to till end of every month whether transactions has done or not on the Basis of Credit & Debit... For Example I have transactions in Jan, Apr,Jun,Jul,Aug...

But user Want to See the Jan Amount only in Feb & March becoz transactions are not done in that months...

Apr Amount Need to be Seen in May becoz transactions are not done in that month...

HOw Can I acheive this any Idea... ?

Find the attached Screen shot...plz help ...

Re: Month is not highlighting ?

avinashelite — Fri, 31 Oct 2014 13:30:24 GMT

Hi Helen,

Can you please provide the sample data.

Re: Month is not highlighting ?

Fri, 31 Oct 2014 13:46:53 GMT

HI Avinash,

I have attached data for 4 customers can you reolve that in above ...plz check...

Regards,

Helen

Re: Month is not highlighting ?

Fri, 31 Oct 2014 13:54:24 GMT

add a new month field which is month + 1 month i.e. Jan becomes feb in the new field and use this for selections?

Re: Month is not highlighting ?

Fri, 31 Oct 2014 14:06:30 GMT

Hai Felim,

If for Example have not done for continuosly for many months , Then it should work, Value you should be carry forwarded by previous months, Can you please do it on the above Data Which I have attached for 4 Customers So that you will Understand...TD_DOC_Amount Should be calculated from TD_DOC_DRCR_FLAG having D & C...Means Debit (Minus) Credit...

please help...

Regards,

Helen