Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Talk to Experts Tuesday, Live Q&A, September 22: Moving from QlikView to Qlik Sense. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator III
Creator III

Month Selection from Week snapshot

Hi Experts ,

i have attached the qvw with dates loaded.. With the attached data i need to see the below month view (in list box) and when i select Jan in that.. latest week of Jan (i.e., 1/28/2017) should get selected.. likewise For Feb (2/25/2017),Mar(3/25/2017) and so on..

Month1.PNG

Highly appreciate on this help!!

Thanks!!

1 Solution

Accepted Solutions
Highlighted

Check the attached

Capture.PNG

View solution in original post

27 Replies
Highlighted

Your attached qvw doesn't have Month field in it.... Are you going to have a Month field in your app or not? I would suggest to add it in the script to make your life easier

Highlighted
Creator III
Creator III

You can add month out of that and try for the output which I was looking for..

Highlighted

Can you share this file so that i can run the qvw

Weeksnapshot.xls

Highlighted
Creator III
Creator III

Here you go!!

Highlighted
Creator III
Creator III

Wrong one attached before.. Here is the one u were looking for

Highlighted

I asked for the Excel file (not the qvw)

Highlighted

Thanks

Highlighted

Check the attached

Capture.PNG

View solution in original post

Highlighted
Creator III
Creator III

TY so much!! We were struggling so much to get this.. In no time u solved!! TY!