Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2022, LIVE in Denver CO., May 16-19, 2022. REGISTER NOW TO RECEIVE EARLY BIRD PRICING
cancel
Showing results for 
Search instead for 
Did you mean: 
marcus_steggall
Creator
Creator

Dyamic Title within Object, ignoring "Date" selection by user

Happy Monday everyone.

I'm hoping this will be a simple calculation, but can't see to get this working (even with set analysis)

I've a chart created using Set analysis, showing a rolling 12 months of data.

Each month, this will automatically update to show the latest 12 months.

So in my title i simply want it to say Aug for example

So i created a variable to show max month.

=month(max(Timelines.Period_Start_Date))  which in this example will come back and show Aug

However, when i then select say Feb from a list of available months... the title updates to Feb.

How can I get this to stand alone in an expression;

  • be fixed to show the system Max month
  • ignoring date selections.

Thanks for your time.

1 Solution

Accepted Solutions
greeshma_k
Creator III
Creator III

If your selection is on Timelines.Period_Start_Date,  then add the condition as shown below. This will ignore the date selection

month(max({<Timelines.Period_Start_Date=>}Timelines.Period_Start_Date))

View solution in original post

3 Replies
greeshma_k
Creator III
Creator III

If your selection is on Timelines.Period_Start_Date,  then add the condition as shown below. This will ignore the date selection

month(max({<Timelines.Period_Start_Date=>}Timelines.Period_Start_Date))

View solution in original post

marcus_steggall
Creator
Creator
Author

Excellent, that's exactly what I wanted and works a treat.

Thank you for your time

Not applicable

Hi,

You can use this.

month(max({<Timelines.Period_Start_Date=>}Timelines.Period_Start_Date))