topic Re: Hows to restrict data between start and end dates in App Development

Hows to restrict data between start and end dates

vinayvishwanath — Thu, 06 Sep 2018 10:30:05 GMT

Hi All,

I want to know on how to restrict the data between start and end dates.

I have 3 fields in data 1. Applications 2. Start date 3. End Date.... the date is in the format of 2017Q1, 2017Q2, 2017Q3...... etc. Start dates start from 2016, 2017,2018 onwards and end dates close with 2017,2018,2019... I want to restrict the data using a filter wherein there should be selection as inprogress,yet to start and expired. here inprogress means end date of app is future date and expired means end date has already passed.Yet to start means apps which have future start date.

Could someone please help me with the script to be used for the above issue

Thanks

Vinay

Re: Hows to restrict data between start and end dates

jonathandienst — Thu, 06 Sep 2018 10:37:43 GMT

Are you looking for something like:

LOAD *,

If([Start date] > Today(), 'Yet to start',

If([End date] > Today(), 'In progress', 'Expired')) as Status

;

LOAD

Application,

[Start date],

[End date],

...

Re: Hows to restrict data between start and end dates

vinayvishwanath — Thu, 06 Sep 2018 16:09:12 GMT

Hi Jonathan,

thanks for the reply, but the solution is not working and i can see though only one status "Yet to start", but upon selection it's not working

Re: Hows to restrict data between start and end dates

jonathandienst — Fri, 07 Sep 2018 14:57:48 GMT

Are your date fields proper numeric Qliksense dates? This won't work if you have loaded dates as text strings.

Why don’t my dates work?

Re: Hows to restrict data between start and end dates

vinayvishwanath — Wed, 12 Sep 2018 07:17:12 GMT

Hi Jonathan,

Your solution worked after creating a resident table for the same