How to Find sales between the range of date selected in Two different list box having source date from same field ?

[moharabi]

Hi ,

I have a single date of engagement field . I have created two list box with names as , «Date début enga» and «Date fin engage» . Both of them refers same date field .

My requirement is User should be able to select a date from «Date début enga» List Box which should not let selection to happen in «Date fin enga» list box .

Then user should get sum of (price * quantite) = Total achat between that range of dates and number of records selected within that range .

I need solution in qlik sense.

Thanks for your help

[pradosh_thakur]

alternate state with extension or may be you need to look at this https://community.qlik.com/thread/237894

[Anonymous]

The way of using Alternate States with data islands and p() is quiet nice.

Works really well.

More discussions & examples:

Comparative Analysis - Alternate States with Qlik Sense

[moharabi]

Hi,

I think you did not understand my question
I want to have a date range and the data that is in a table is displayed according to the selected date

[Anonymous]

Hi Nabila,

I was refering to Pradosh's post.

If you want to use the between date selection you may find useful to look at an extension called

Data Picker.

Date Range Picker for Bootstrap

Attached zipped file.

Kind regards,

Chris.

[moharabi]

Do you have another extension validated by Qlik. I can not use this one in our company.

[MK9885]

Maybe this one?

http://branch.qlik.com/#!/project/5697a878dcc497f80ed514bf

[moharabi]

thank you for your answers. the extention works very well

[MK9885 · Accepted solution]

If you could mark the answer as correct so that this post would be closed?

Thanks.