I need to display month and week as shown below in a Qlikview application object.
my data is in this format, excel file is attached
if i select any cell (week number) in the object, only the week of that particular month should be selected in the application.
Please suggest how such an object can be created.
Thanks for your reply, one more addition to the requirement. Is it possible to show the selected value in green and all other values in grey. Basically we wants to show the entire month week calendar all the time even if a selection is made by the user.
Sorry for late mentioning, in our actual data those week values are actually monthly week numbers. so we are are not getting the desired pivot table result. PFA the revised excel sheet.