topic How Show Delta Data ( Difference in dates) in QlikView

How Show Delta Data ( Difference in dates)

Thu, 09 Jul 2009 22:16:38 GMT

HI Experts,

I am fetching Data from Oracle Server,there is one table which have cumulative data date wise,but i have to show actual data on chart.[:'(]

Like..

Data Stores Like this.

sales As On 10-July-2009 = 1000

As On it 11-July-2009 it is = 1050.

As On 12-July-2009 it is = 1110.

And I want to show.

10-July-2009 = 1000

11-July-2009 = 50

12-July-2009 = 60

and so on

I am attaching you my sample application for your review.

Thanks & regards.

Anwar

How Show Delta Data ( Difference in dates)

prieper — Fri, 10 Jul 2009 04:54:42 GMT

Hi,

as you are interested in absolute values, makes sense to hardcode the difference in the script.

Tab2: LOAD *, Sales - Peek(Sales) AS Diff RESIDENT Tab1 ORDER BY MyDate;

DROP TABLE Tab1;

When there are more keys, need to include this in the sorting and to add a conditional clause, like

If Field1 = Peek(Field1), Sales ....

HTH

Peter

How Show Delta Data ( Difference in dates)

Fri, 10 Jul 2009 13:46:03 GMT

hi,

Thanks 4 reply..but its not showing correct value.please c my data..

How Show Delta Data ( Difference in dates)

disqr_rm — Fri, 17 Jul 2009 20:55:55 GMT

Here you go. See enclosed.

In the expression I have used "fabs" as you want value 84 and not -84 for the second month. "fabs" just make it positive value.

Hope this helps.

How Show Delta Data ( Difference in dates)

Mon, 20 Jul 2009 18:09:14 GMT

Gud Man....

How Show Delta Data ( Difference in dates)

Sun, 12 Jun 2011 15:26:14 GMT

Hi,

Thanks for your help. How would you skip the first record? (10.006)?

Reason: if I consider getting the first data into my report, daily sales amount will not be presentable in the chart. (Daily sales is around 30, starting value is 10.006)

Thanks again