topic Re: Display month and week in QlikView

Display month and week

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

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

Re: Display month and week

sunny_talwar — Wed, 08 Feb 2017 15:55:16 GMT

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

Re: Display month and week

Anonymous — Wed, 08 Feb 2017 16:19:01 GMT

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

Re: Display month and week

ganeshreddy — Thu, 09 Feb 2017 08:46:32 GMT

Thanks Cosmina

Re: Display month and week

ganeshreddy — Thu, 09 Feb 2017 10:41:31 GMT

Hi Sunny,

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

Re: Display month and week

sunny_talwar — Thu, 09 Feb 2017 10:43:17 GMT

You got the solution already, right?

Re: Display month and week

ganeshreddy — Thu, 09 Feb 2017 11:09:25 GMT

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

Re: Display month and week

Anonymous — Thu, 09 Feb 2017 12:05:58 GMT

Hi,

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

Best regards,

Cosmina

Re: Display month and week

ganeshreddy — Thu, 09 Feb 2017 13:26:06 GMT

Yes Sunny,

i got the solution, thanks

Re: Display month and week

ganeshreddy — Thu, 09 Feb 2017 13:27:26 GMT

You are a genius!! thanks again.

-Ganesh