Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Attend QlikWorld 2020 and hear keynote speaker, Malcolm Gladwell. Register by February 29th to save $200. Learn More
ganeshreddy
Contributor 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
Highlighted
cocosmina
Contributor II

Re: Display month and week

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
Highlighted

Re: Display month and week

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

Highlighted
cocosmina
Contributor II

Re: Display month and week

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

Highlighted
ganeshreddy
Contributor III

Re: Display month and week

Thanks Cosmina

Highlighted
ganeshreddy
Contributor III

Re: Display month and week

Hi Sunny,

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

Highlighted

Re: Display month and week

You got the solution already, right?

Highlighted
ganeshreddy
Contributor III

Re: Display month and week

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

Highlighted
cocosmina
Contributor II

Re: Display month and week

Hi,

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

Best regards,

Cosmina

View solution in original post

Highlighted
ganeshreddy
Contributor III

Re: Display month and week

Yes Sunny,

i got the solution, thanks

Highlighted
ganeshreddy
Contributor III

Re: Display month and week

You are a genius!! thanks again. 

-Ganesh