Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join us for a live Q&A! September 21, 10 AM ET - Onboarding Fast in Qlik Sense SaaS! REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
waqasshah
Creator
Creator

YTD Month Names Selection

Dear All,

I need your help. It seems to be simple issue but becomes critical. I have attached two screenshots.  My financial year values ranges from April - March.

E.g.  We are in  November so I want the month from April -- October will be highlighted/selected by default  when the sheet is  loading . Please review the second screenshots

Can someone please help?

Kind Regards

Waqas Shah

 

 

 

 

 

Labels (1)
2 Replies
MayilVahanan

Hi

Try like this in OnOpen Trigger -> select in field

Field: Month
Search string:
='('&Concat(Aggr(Only({<Date={'<$(=Date(Monthstart(Today())))'}>}Month),Month),'|', Month)&')'

Change the expression based on your fiscal date field and fiscal month field
Hope it helps.
Thanks & Regards,
Mayil Vahanan R
waqasshah
Creator
Creator
Author

Dear Mayilvahanan ,

Many thanks for your reply.  I have tried using your code by replacing with my requirements. Please review the following code

Field: Month : YOYMonthNames

='('&Concat(Aggr(Only({<Date={'<$(=Date(Monthstart(Today())))'}>}YOYMonthNames),YOYMonthNames),'|', YOYMonthNames)&')'

  Please note my field YOYmonthNames is returning me the month names already. Your code highlight all the months in the list box.

 

I have used your code in the text box and in the listbox and all the months were displayed but in different order.  Basically I want the months highlighted will be from April  until October.  Thanks in advance for ur help.

Please  have a look on the latest screenshot.

 

 

Kind Regards

Waqas Shah