Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have a requirement to show dates in Table or as a individual field (by dragging it to sheet) to use it as date filter on my qlik sense dashboard.
I want to show only 5 dates greater than particular date say it is stored in some variable.
I was able to show dates greater than particular date but how can I limit them to 5?
I am using this expression =if([SETTLE_DATE]>='$(MyDate)',SETTLE_DATE)
How can I change this expression so that It will show only top 5 dates.
HI,
try below
Create a variable ,
LET vTop5=Date(max([SETTLE_DATE])-5);
Expression : If([SETTLE_DATE]>'$(MyDate)' and [SETTLE_DATE]> '$(vTop5)',[SETTLE_DATE])
Thanks,
sasi
LET vTop5=Date(max([SETTLE_DATE])-5); this is not getting evaluated.
I would like to highlight that SETTLE_DATE are not in sequence
example-
Let MyDate = Date('7/16/2019');
and settle dates are as following
7/16/2019
7/17/2019
7/18/2019
7/19/2019
7/22/2019
7/23/2019
7/16/2019
Expected output is -
7/16/2019
7/17/2019
7/18/2019
7/19/2019
7/22/2019
Create a variable at front end and use that variable in expression or use expression directly ,
=if([Order Date]>'$(=Date(max([Order Date]-5)))' and [Order Date]>'$(=Date(max([Order Date]-10)))' , [Order Date])
Thanks,
Sasi