Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
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

2 Replies
Not applicable
Author

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
Author

Hi Shruthi,

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

Thank you very much.

Regards,

Renyta