Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
prabhas277
Creator
Creator

middle date sales

hi experts,

i have table like this

load * inline [

date, sales

1/1/2015,100

1/2/2015,200

1/3/2015,300

1/4/2015.400

1/5/2015.500

1/6/2015,600

1/7/2015,700

];

if i select 2 dates i.e 1/2/2015 and 1/6/2015 then i want see only middle date sales i.e 300,400,500. what is the way to approach?

4 Replies
kaushiknsolanki
Partner Ambassador/MVP
Partner Ambassador/MVP

Hi,

Try below expression.

Sum({<Date = {">$(=Min(Date)<$(=Max(Date)))"}>}Sales)

Regards,

Kaushik Solanki

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!
maxgro
MVP
MVP

Sum({$ <date={">$(=date(Min(date)))<$(=date(Max(date)))"}>} sales)

see attachment

Kushal_Chawda

Make sure that you Date field is in proper date format, else create the Date with date(date#(date, 'MM/DD/YYYY')) as date

then try below expression in set analysis

Sum({<Date = {">$(=Min(date)<$(=Max(date)))"}>}Sales)

Not applicable

This will work .