topic Re: The result should be greater than selected date. in App Development

The result should be greater than selected date.

irshadvaza — Mon, 30 Nov 2020 11:12:10 GMT

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

Re: The result should be greater than selected date.

RsQK — Mon, 30 Nov 2020 11:24:18 GMT

Hey!

On the front-end you could simply do this:

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

Re: The result should be greater than selected date.

irshadvaza — Mon, 30 Nov 2020 12:28:42 GMT

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,

Re: The result should be greater than selected date.

GaryGiles — Mon, 30 Nov 2020 19:38:39 GMT

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.

Re: The result should be greater than selected date.

irshadvaza — Mon, 07 Dec 2020 05:33:15 GMT

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.