The result should be greater than selected date.

[irshadvaza]

Hello Friends,

I am looking for extension of solution for the below scenario.

When user select the date in date control or extension, the result should be greater than selected  date. 

It would be great if anyone help to get the solution along with date control.

For example. 

ID     Date                             Value

1      12/12/2020                  10

2       10/05/2019                  5

3        29/11/2020                 15

4        20/12/2021                 22

5           06/06/2020              11

if user select the 29/11/2020, then should return the below data.

ID     Date                             Value

1      12/12/2020                  10

4        20/12/2021                 22

5           06/06/2020              11

[RsQK]

Hey!

On the front-end you could simply do this:

Sum({<Date={">$(=Date(Max(Date),'DD/MM/YYYY'))"}>}Value)

[irshadvaza]

Thanks for response.

your solution is related to sum of selected date however I am looking of  calendar control where user can select a date and he can see all the data which is greeter then selected date.

Regards,

[GaryGiles]

One option is to create an island table in your load script that is not connected to your data model.

DateSelect:
Load Distinct Date as SDate
Resident Sample;

Then, use the Date Picker object in the Qlik Dashboard bundle with the SDate field as your date selection control.

In your table, use the following expression as a dimension:

=aggr(max({1<Date={">=$(=min(SDate))"}>} Date),Date)

And add other dimensions and measures as needed in the table/pivot.

[irshadvaza]

Thank you so much Gary, I tried to implement as per your advice however, date picker is not working when I select Single Date option.