Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi Renyta,
you can have an inline table for defining the prev 3 months for each month.
check the attached QVW.
Thanks,
Shruthi
Hi Shruthi,
Thanks for your reply, your answer is really helpful..
Thank you very much.
Regards,
Renyta