Hows to restrict data between start and end dates

[vinayvishwanath]

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

[jonathandienst]

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],

    ...

[vinayvishwanath]

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

[jonathandienst]

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?

[vinayvishwanath]

Hi Jonathan,

Your solution worked after creating a resident table for the same