topic Re: Expression Help ! in QlikView

Expression Help !

sona_sa — Wed, 01 Aug 2018 14:06:03 GMT

Hi All,

I have the data like :

QVD Name	QVD Size (KB)	QVD Time
ata.qvd	1,908.99	8/1/2018 12:10:30 AM
ata.qvd	1,911.11	8/1/2018 4:25:48 AM
ata.qvd	1,914.80	8/1/2018 8:21:14 AM

If you will check same QVD has reloaded 4 Hrs of Interval. Now I need the calculation, whenever it will reload next time What is the QVD size difference from the last reload time.

How I can make an expression from the same.

Can you help me on this.

Thanks.

Re: Expression Help !

sunny_talwar — Wed, 01 Aug 2018 14:09:32 GMT

May be this

FirstSortedValue([QVD Size (KB)], -[QVD Time]) - FirstSortedValue([QVD Size (KB)], -[QVD Time], 2)

Re: Expression Help !

Gysbert_Wassenaar — Wed, 01 Aug 2018 14:10:46 GMT

If you want to do this in a straight table or pivot table you can use the above function: sum([QVD Size (KB)]-above(sum([QVD Size (KB)]).

If you want to do it in the script you can use the Previous function. You may need to use a resident load to order the data by QVD Time first. If you need help with that it would be useful if you could post the part of your script that create the table with the data you posted.

Re: Expression Help !

sona_sa — Wed, 01 Aug 2018 14:33:19 GMT

Hi All,

I have the data like :

QVD Name	QVD Size (KB)	QVD Time
ata.qvd	1,908.99	8/1/2018 12:10:30 AM
ata.qvd	1,911.11	8/1/2018 4:25:48 AM
ata.qvd	1,914.80	8/1/2018 8:21:14 AM

If you will check same QVD has reloaded 4 Hrs of Interval. Now I need the calculation, whenever it will reload next time What is the QVD size difference from the last reload time.

How I can make an expression from the same.

Can you help me on this.

Thanks.

Re: Expression Help !

sona_sa — Wed, 01 Aug 2018 14:40:13 GMT

Hi Gysbert,

Thanks for reply. Please find the attached xls for the same.

Please if you have time look into this.

Thanks.

Re: Expression Help !

Gysbert_Wassenaar — Wed, 01 Aug 2018 15:27:01 GMT

See attached example

Re: Expression Help !

sona_sa — Thu, 02 Aug 2018 04:27:22 GMT

Thanks Gysbert.

But we are missing -ve sign.

ata.qvd	1498.282227	13/06/2018 04:42:10
ata.qvd	1500.69043	13/06/2018 08:32:10	2.408203125	3:50:00	-2.4082

I tried to fix it, Not success. Second also can we make a new field means what percentage of QVD size has been done from last reload time to current time.

Re: Expression Help !

sona_sa — Thu, 02 Aug 2018 12:52:54 GMT

Hi Gysbert,

Have you checked my previous post. Is it -ve.

Thanks

Re: Expression Help !

sunny_talwar — Thu, 02 Aug 2018 12:57:10 GMT

For getting a negative value... may be try this

If(Previous([QVD Name]) = [QVD Name], Previous([QVD Size (KB)]) - [QVD Size (KB)]) as [QVD Size Change],

instead of this

If(Previous([QVD Name]) = [QVD Name], [QVD Size (KB)] - Previous([QVD Size (KB)])) as [QVD Size Change],

Re: Expression Help !

sona_sa — Thu, 02 Aug 2018 13:04:16 GMT

Hi Sunny,

what percentage of QVD size has been done from last reload time to current time. In the straight table.

Thanks.

Re: Expression Help !

sunny_talwar — Thu, 02 Aug 2018 13:05:50 GMT

What percentage of QVD Size has been done? What do you mean when you say has been done? Can you provide the expected output based on the input QVD Diff file you have provided?

Re: Expression Help !

sona_sa — Thu, 02 Aug 2018 13:10:56 GMT

My mean to say, How many % of is changed from old QVD size to New QVD size. After reload. Because it is refreshing an interval of 3 Hours frequently.