topic Re: middle date sales in QlikView

middle date sales

prabhas277 — Mon, 24 Aug 2015 18:32:25 GMT

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?

kaushiknsolanki — Mon, 24 Aug 2015 18:34:13 GMT

Hi,

Try below expression.

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

Regards,

Kaushik Solanki

maxgro — Mon, 24 Aug 2015 18:38:17 GMT

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

see attachment

Kushal_Chawda — Mon, 24 Aug 2015 18:39:41 GMT

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)

Mon, 24 Aug 2015 18:57:07 GMT

This will work .