Qlik Community

QlikView Deployment

Discussion Board for collaboration related to QlikView Deployment.

Not applicable

can i get dummy dimension for MonthYear data

Hi,

I have a field called MonthYear and I want to make a dummy dimension that the value is 3 of previous MonthYear from the current selection.

example: if my current selection is year=2013 and month=July so my dummy dimension is May 2013, Jun 2013, Jul 2013.

Can I make it like that on qlikview?

Best Regards,

Renyta

Tags (1)
2 Replies
Not applicable

Re: can i get dummy dimension for MonthYear data

Hi Renyta,

you can have an inline table for defining the prev 3 months for each month.

check the attached QVW.

Thanks,

Shruthi

Not applicable

Re: can i get dummy dimension for MonthYear data

Hi Shruthi,

Thanks for your reply, your answer is really helpful..

Thank you very much.

Regards,

Renyta

Community Browser