This field is required.
Only these extensions are allowed(.jpg, .JPG, .jpeg, .JPEG, .gif, .GIF, .png, .PNG)
Tags cannot contain the characters ' /, \\, #, ?, or ; >,< '
Only these extensions are allowed(.zip,.ZIP,.pdf,.PDF,.qvf,.QVF,.qvw,.QVW)
Discussion Board for collaboration related to QlikView App Development.
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;
Thanks for your time.
If your selection is on Timelines.Period_Start_Date, then add the condition as shown below. This will ignore the date selection
View solution in original post
Excellent, that's exactly what I wanted and works a treat.
Thank you for your time
You can use this.