topic Re: Populate data based on date in QlikView

Populate data based on date

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hi All,

I have a requirement where in we need to populate Names based on the below condition.

We have a date called expire date set against each name and we need to populate the data in a table format where in it shows those names which has expire date coming up in 90 days.

The data that are there in the application and should be shown in the table are:

Name

Region

Expire date,

Amount

Kindly let me know if you need more information regarding this

Thanks in advance

Anupama Jagan

Re: Populate data based on date

vishsaggi — Wed, 12 Apr 2017 14:09:40 GMT

Can you provide some sample data and expected output please ?

Try something like

Table:

LOAD *,

IF(ExpireDate = Date(Today() + 90, 'MM/DD/YYYY'), 'Expiring in 90', 'InDate') AS ExpiredFlag;

LOAD * Inline [

Group, Product, Amount, ExpireDate

a, Jam, 10, 7/11/2017

a, chinese, 20, 7/11/2017

c, Frozen, 30,4/12/2017

c, Pickle, 40, 7/11/2017

d, Tea, 50,4/12/2017

d, kora, 60,12/12/2017

];

Re: Populate data based on date

Anonymous — Wed, 12 Apr 2017 15:04:22 GMT

Hi Vishwarath,

I have attached the sample data in the original post

The output should show all the Qnums which has expiration date in next 90 days.

The table should contain

QNums, PNums

In your example it shows all products which expires exactly in 90 days right. My requirement is it should display only those QNums which will be expired in next 90days from current date.

Kindly let me know if you need more information regarding this.

Thanks,

Anupama Jagan

Re: Populate data based on date

vishsaggi — Wed, 12 Apr 2017 16:53:10 GMT

Check attached?

Re: Populate data based on date

Wed, 12 Apr 2017 18:32:49 GMT

Hi,

Try to create a new date in script witch is your expire date + 90 and then you can use set analysis for the rest.

See the sample attached.

Regards,