Get the Previous Month Data

[#1]

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.

[its_anandrjs]

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

[#3]

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.

[#4]

Hi,

Refer to the below link. Stefano had a solution.

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

Thanks

[its_anandrjs]

Hi,

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

Rgds

Anand