Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

moharabi
New Contributor II

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

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

Tags (1)
1 Solution

Accepted Solutions
arvind654
Honored Contributor II

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

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

Thanks.

8 Replies
pradosh_thakur
Valued Contributor III

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

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

krzysztof_toman
New Contributor III

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

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
New Contributor II

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

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

krzysztof_toman
New Contributor III

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

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
New Contributor II

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

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

arvind654
Honored Contributor II

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

moharabi
New Contributor II

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

thank you for your answers. the extention works very well

arvind654
Honored Contributor II

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

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

Thanks.