Limit the number of records in Qlik sense visualization control

[dhirajkhodade]

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.

[sasikanth]

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

[dhirajkhodade]

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

[sasikanth]

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