Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a Date Field and I created Date Ranges for the Dates in the Field.
I need to show both Start Date and End Date in a Text Box for the Date Range Selected.
If I select 'Last 7 Days' in the Date Range, the following dates are selected in the Date Field
10/5/2020 |
10/6/2020 |
10/7/2020 |
10/8/2020 |
10/9/2020 |
10/10/2020 |
10/11/2020 |
10/12/2020 |
Th Start and End Dates should show as
Start Date: 10/5/2020
End Date: 10/12/2020
It should change as per Date Range Selection.
Please refer to the QVW attached for Sample
I'm not able to examine your qvw at the moment, but if your date field is formatted as a date then you could use the two following expressions to get the first and last date in your selection.
=MinString([Date])
=MaxString ([Date])
I hope this was of help.
Vegar
@qlikwiz123 what is the problem? Looks like your selections works as expected
@Kushal_Chawda Yes. The requirement is not just the Date Range Selections.
I just need to create Text Boxes to show start and end dates based on the Date Range Selection
For example, if I select 'Last 7 Days', the Start Date text Box should show 10/5/2020 and End Date Text box should show 10/12/2020
I'm not able to examine your qvw at the moment, but if your date field is formatted as a date then you could use the two following expressions to get the first and last date in your selection.
=MinString([Date])
=MaxString ([Date])
I hope this was of help.
Vegar
@Vegar Thanks Vegar, this is what I was looking for. Thank you again
@Kushal_Chawda Thanks Kush, Guess I can use your solution going forward when my other date problems increase 🙂
That's great!
Make sure you close this thread by accepting the answer as an solution. This will help others with a similar problem searching for answers in the future and it will inform other helping users that they can move along and help in the next post since you have got what you came for in this thread.
Have a nice day.
Vegar