Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Now Live: Qlik Sense SaaS Simplified Authoring – Analytics Creation for Everyone: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
ganeshreddy
Creator III
Creator III

Display month and week

Hi All,

I need to display month and week as shown below in a Qlikview application object.Capture111.PNG

my data is in this format, excel file is attached

Capture2222.PNG

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

1 Solution

Accepted Solutions
cocosmina
Creator II
Creator II

Hi,

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

Best regards,

Cosmina

View solution in original post

9 Replies
sunny_talwar

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

cocosmina
Creator II
Creator II

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
Creator III
Creator III
Author

Thanks Cosmina

ganeshreddy
Creator III
Creator III
Author

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
Creator III
Creator III
Author

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

Capture4444.PNG

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

cocosmina
Creator II
Creator II

Hi,

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

Best regards,

Cosmina

ganeshreddy
Creator III
Creator III
Author

Yes Sunny,

i got the solution, thanks

ganeshreddy
Creator III
Creator III
Author

You are a genius!! thanks again. 

-Ganesh