Three months earlier

[pgalvezt]

Hello,

Currently I'm working on debt models. I'm trying to extract the 3 months earlier with another table. For example If I do clic on Jan2011 I need to get Nov2011, Dic2011,Jan2011. If I do clic On Feb2011 I need to get Dic2011, Jan2011,Feb2011 and so on. How ca I do achieve this?

I left an attached sample for better comprenhension.

Thank You!

[Gysbert_Wassenaar]

Create a table like this

ReportMonth, PeriodMonth

Jan2011, Nov2010

Jan2011, Dec2010

Jan2011, Jan2011

Feb2011, Dec2010

Feb2011, Jan2011

Feb2011, Feb2011

etc..

You can then join that table to the other data on PeriodMonth and use ReportMonth to select the Month that determines the period you want to report over. 

[pgalvezt]

Hi, Thank you for your reply.

In my new table I added periodo field (join with periodo on table T) But The table appears unable. How could avoid this?

I left a new qv sample.

Thank you!

[Gysbert_Wassenaar]

I have no idea what's happening. Your Sample.qvw contains no data at all, so I can't tell anything about it.

[pgalvezt]

If I reload this qvw will weight 50 MB. Is there another way that you can see the data?

[pgalvezt]

Ok! There is.

[Gysbert_Wassenaar]

That helps a lot! In table Tarjetas you have field Periodo, but in Report_Table you have no field with that name. It's named PeriodoMes. So qlikview can't find matching field names in the two tables and thus doesn't join them. If you rename PeriodoMes in Periodo the two tables will be joined and you can use ReportMes to select the appropriate months.

edit: Maybe you want to rename PeriodoMes to Fecha_Protesto. Doesn't that field contain the months of the period?

[pgalvezt]

I did that but there is a problem with the date maybe.

[Gysbert_Wassenaar]

Yes, the formats are different. Make sure the months in Report_Table are the same data type as in the field Fecha_Protesto.

[pgalvezt]

Ok I fixed it. Now How can I extract the 3 months? like I explained in my first post?

Thank You!