topic Re: Get the Previous Month Data in QlikView

Get the Previous Month Data

Tue, 11 Oct 2011 11:34:18 GMT

Hi All,

I need the output as mentioned attached file. I have tried with peek function that is giving correct results but i need some thing different in set analysis.

Regards,

Ravi.

Re: Get the Previous Month Data

its_anandrjs — Tue, 11 Oct 2011 11:58:29 GMT

Hi,

I suggest you have to load data some thing like this and use it in pivot table.

See the attached sample file.

Rgds

Anand

Re: Get the Previous Month Data

Tue, 11 Oct 2011 12:30:04 GMT

Hello Anand,

Try to get the solution with if data is missing for that month place the previous month data using peek or set analysis.

Regards,

Ravi.

Re: Get the Previous Month Data

Tue, 11 Oct 2011 12:33:17 GMT

Re: Get the Previous Month Data

Tue, 11 Oct 2011 13:41:55 GMT

Hi,

Refer to the below link. Stefano had a solution.

http://community.qlik.com/thread/36359

Thanks

Re: Get the Previous Month Data

Tue, 11 Oct 2011 14:37:44 GMT

Re: Get the Previous Month Data

its_anandrjs — Tue, 11 Oct 2011 18:52:38 GMT

Hi,

Ok i understood but it is too late now tomorrow i provide details about this to you.

Rgds

Anand