topic Re: In a straight table is it possible to do aging calculation based on date of each record in QlikView

In a straight table is it possible to do aging calculation based on date of each record

vvira1316 — Mon, 21 Nov 2016 16:00:33 GMT

Hi,

I've a straight table in which I need to do calculation based on date field of each record and today's date to find aging. Will it be possible to achieve it?

Please find information below. the calculation is based on today's date - [Request Date] for each Document ID.

Thanks,

Vijay

Re: In a straight table is it possible to do aging calculation based on date of each record

sunny_talwar — Mon, 21 Nov 2016 16:09:53 GMT

You should be able to do this

=Today() - [Request Date]

Have you already tried this?

Re: In a straight table is it possible to do aging calculation based on date of each record

vvira1316 — Mon, 21 Nov 2016 16:48:46 GMT

Hi Sunny,

Thanks for the reply. That is working. I've another situation where I'm trying to construct URL based on a field that has URL information but it is not available in all records. I've included that table below. Any idea for that one will be helpful.

I need to construct link from web address for a record where URL info is present (href value from below table)

[Document ID] & Chr(60) & 'URL' & Chr(62) & SubField(MaxString([Web Address]),'"',2)

How to use a field value of a particular/current record within set analysis to create hyperlink using information from t…

Re: In a straight table is it possible to do aging calculation based on date of each record

vvira1316 — Mon, 21 Nov 2016 21:51:40 GMT

if I use same calculation in Text color than I'm not getting the right count in the table.

I'm having following expression in Text Color of the calculated dimension

=If((Today()-[Request Date])>2,RGB(174,30,35))

but it causes incorrect record count.

Any guidance?

Thank you in advance.

I figured my error and got it working using expression instead of doing calculation as a dimension.

Re: In a straight table is it possible to do aging calculation based on date of each record

sunny_talwar — Tue, 22 Nov 2016 01:49:25 GMT

So what is still not working? Or is everything resolved?

Re: In a straight table is it possible to do aging calculation based on date of each record

vvira1316 — Tue, 22 Nov 2016 14:43:11 GMT

Hi Sunny,

Everything is working. Thanks for checking.

Regards,

Vijay