topic Re: Month Selection from Week snapshot in QlikView

Month Selection from Week snapshot

bharani8 — Wed, 25 Nov 2020 16:16:04 GMT

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..

Highly appreciate on this help!!

Thanks!!

Re: Month Selection from Week snapshot

sunny_talwar — Fri, 07 Jul 2017 12:22:26 GMT

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

Re: Month Selection from Week snapshot

bharani8 — Fri, 07 Jul 2017 12:30:21 GMT

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

Re: Month Selection from Week snapshot

sunny_talwar — Fri, 07 Jul 2017 12:36:00 GMT

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

Weeksnapshot.xls

Re: Month Selection from Week snapshot

bharani8 — Fri, 07 Jul 2017 12:38:31 GMT

Here you go!!

Re: Month Selection from Week snapshot

bharani8 — Fri, 07 Jul 2017 12:39:31 GMT

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

Re: Month Selection from Week snapshot

sunny_talwar — Fri, 07 Jul 2017 12:40:03 GMT

I asked for the Excel file (not the qvw)

Re: Month Selection from Week snapshot

sunny_talwar — Fri, 07 Jul 2017 12:40:11 GMT

Thanks

Re: Month Selection from Week snapshot

sunny_talwar — Fri, 07 Jul 2017 12:42:15 GMT

Check the attached

Re: Month Selection from Week snapshot

bharani8 — Fri, 07 Jul 2017 12:48:52 GMT

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

Re: Month Selection from Week snapshot

bharani8 — Fri, 07 Jul 2017 12:58:27 GMT

Hi Sunny - Just a qq.. Instead of date field, if i have the attached Time stamp field.. can you show how t works for the same output? Attached is the file FYR..

Re: Month Selection from Week snapshot

sunny_talwar — Fri, 07 Jul 2017 13:06:03 GMT

Here you are

Re: Month Selection from Week snapshot

bharani8 — Fri, 07 Jul 2017 13:31:53 GMT

ok Cool!!!

Re: Month Selection from Week snapshot

bharani8 — Fri, 07 Jul 2017 13:53:09 GMT

Hi Sunny - One more challenge am facing after this

Challenge is am not able to select more than one month at a time in the below list box.. Any workaround for this ?

Re: Month Selection from Week snapshot

sunny_talwar — Fri, 07 Jul 2017 13:59:04 GMT

What should happen if you select more than 1 Month?

Re: Month Selection from Week snapshot

bharani8 — Fri, 07 Jul 2017 14:02:23 GMT

I have few charts below these list box.. For which i have month dimension... So when i select Eg., Jan and Feb.. Data for those 2 months (i understand Max week of those months reflects..still fine) should get reflected in the chart..

Re: Month Selection from Week snapshot

sunny_talwar — Fri, 07 Jul 2017 14:04:58 GMT

So if you select Jan and Feb, you would want the last week date to be selected for both Jan and Feb?

Re: Month Selection from Week snapshot

bharani8 — Fri, 07 Jul 2017 14:06:14 GMT

Yes.. Perfect!

Re: Month Selection from Week snapshot

sunny_talwar — Fri, 07 Jul 2017 14:11:37 GMT

Here you are

Re: Month Selection from Week snapshot

bharani8 — Fri, 07 Jul 2017 14:39:29 GMT

Am not getting the output in mine.. Only thing that is different in my script and your script is

in your script- TimeStamp(Date#(REFERENCE_DT, 'M/D/YYYY h:mm:ss')) as Date,

in my script- Date(TimeStamp(Date#(REFERENCE_DT, 'M/D/YYYY h:mm:ss')),'MM/DD/YYYY') as Date,

As i need the date to be in MM/DD/YYYY format i added that in my script in front of my Timestamp..Not sure where i went wrong..

please find the attached files which i tested.. Can u bring the output in this file plz?