fromdate and to date

kunkumnaveen — Wed, 03 Feb 2016 12:12:42 GMT

Hello All,

my requirement is that i need to pick the data between fromdate and todate fields which has to be created on me own ,i mean to say that client provide me only a created date field, by using that field i should create a fromdate and todate

for example my data is like this let assume because i cant give real data as example

createddate no.of lots accepted rejected

01/01/2015 10 9 1

01/02/2015 20 19 1

01/30/2015 30 28 2

02/15/2015 10 8 2

02/20/2015 5 3 2

So my requirement is i need to create a from date and a to date field,so if end user select

fromdate :01/01/2015 from drop down

to date: 01/30/2015 from drop down

then result should be like this:

NO OF LOTS:60

my assumption for this requirement is to create two varibles

set vfromdate=min(createddate);

set vtodate=max(createddate);

and my doubt is do i need to use any triggers kind of thing ....please any overview navigation that will be appreciated and please dont route me to that date picker youtube video ............

thank

naveen

Re: fromdate and to date

settu_periasamy — Tue, 09 Feb 2016 03:31:44 GMT

Hi,

If you didn't achieve the result, check the attachment. May be helps..

Re: fromdate and to date

HirisH_V7 — Tue, 09 Feb 2016 04:29:28 GMT

Hi,

Check this,

This May help you out

PFA,

Hirish

Re: fromdate and to date

kkkumar82 — Tue, 09 Feb 2016 07:41:09 GMT

Hi Naveen,

Just adding to setu using Input boxes. You can find in second sheet.

Thanks

Kiran kumar

topic Re: fromdate and to date in QlikView

fromdate and to date

Re: fromdate and to date

Re: fromdate and to date

Re: fromdate and to date