Display month and week

[ganeshreddy]

Hi All,

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,

Ganesh

[sunny_talwar]

Is week a date or is it actually saying Week1, Week2, Week3, Week4?

[Anonymous]

Hi,

Make a pivot table, with dimensions Month and week, and as expression aggr(ONLY(Week),Month,Week). I have attached the app.

Best regards,

Cosmina

[ganeshreddy]

Thanks Cosmina

[ganeshreddy]

Hi Sunny,

It is actually a week period (Ex: For P101 for month period 1 and week1)

[sunny_talwar]

You got the solution already, right?

[ganeshreddy]

Hi Cosmina,

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.

PFB

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.

Thanks,

Ganesh

[Anonymous · Accepted solution]

Hi,

Please find attached. The colors are at the expression, you have to expend the +.

Best regards,

Cosmina

[ganeshreddy]

Yes Sunny,

i got the solution, thanks

[ganeshreddy]

You are a genius!! thanks again. 

-Ganesh