topic Re: Get data between dates in QlikView

Get data between dates

gidon500 — Tue, 27 Sep 2016 04:21:09 GMT

Hi Guys

I need your help to solve the customer request .

enclosed is a file with data of :

DOCDATE date of transaction

QUANT qty

WARHS no ,

TYPE of transaction .

and more

I need to create SUM of QUANT ( per WARHS from today to date1 - that will be given as variable - for ex 01/09/2015

I need to create SUM of QUANT ( per WARHS from today to date2 - that will be given as variable - for ex 15/09/2015

and sum of QUANT between date1 to date2 where TYPE = 'M'

thanks for your help

have a nice day .

gidon

Re: Get data between dates

trdandamudi — Tue, 27 Sep 2016 04:54:48 GMT

I was not clear on the out put that you need but you can take a look and the below and see if this is what you want.. If not can you please share your expected out put...

Or may be this:

Re: Get data between dates

gidon500 — Wed, 28 Sep 2016 05:37:40 GMT

Hi Thirumala

thanks for your answer

I think there is one problem

SUM FOR DATE 1 is Ok

SUM FOR DATE 2 if Ok

BUT SUM BETWEEN DATES IS WRONG I THINK

thanks

for your help

gidon

Re: Get data between dates

Anil_Babu_Samineni — Wed, 28 Sep 2016 05:42:55 GMT

Gidon David wrote:

Hi Thirumala

thanks for your answer

I think there is one problem

SUM FOR DATE 1 is Ok

SUM FOR DATE 2 if Ok

BUT SUM BETWEEN DATES IS WRONG I THINK

thanks

for your help

gidon

Then try this for diff

Interval(Sum([DATE 1]) - Sum([DATE 2]))

Re: Get data between dates

tresB — Wed, 28 Sep 2016 05:46:08 GMT

A small correction would be required in the expression. Try like:

sum({<DOCDATE={'>=$(=date(vdate1)) <=$(=date(vdate2))'},TYPE={'M'}>} QUANT)

Re: Get data between dates

Anonymous — Wed, 28 Sep 2016 05:46:12 GMT

try like this?

1) sum({<DateField={'>=$(=Date(Date1))<=$(date(today()))'}>} QUANT)

2) sum({<DateField={'>=$(=Date(Date2))<=$(date(today()))'}>} QUANT)

3) 1) sum({<Type={'M'},DateField={'>=$(=Date(Date1))<=$(date(Date2))'}>} QUANT)

make sure format of all date fields value should be same.

Re: Get data between dates

maniram23 — Wed, 28 Sep 2016 05:58:07 GMT

HI,

Please Check it below attached file.

Re: Get data between dates

trdandamudi — Wed, 28 Sep 2016 06:23:23 GMT

Can you try the below expression as tresesco suggested for the between dates:

sum({<DOCDATE={'>=$(=date(vdate1)) <=$(=date(vdate2))'},TYPE={'M'}>} QUANT)

If that is not correct, can you share the output....

Re: Get data between dates

gidon500 — Wed, 28 Sep 2016 06:35:03 GMT

Hi guys

thanks for the help

it is correct answer , that is the way to do it

gidon