topic Re: calculated values in QlikView

calculated values

Wed, 25 Nov 2020 16:16:04 GMT

Dear All,

I'm new and I woluld like to have calculated values as diff from meter counter ,

date	meter counter	diff
2017-04-04 01:00	22628
2017-04-04 02:00	22629,7	1,7
2017-04-04 03:00	22631,4	1,7
2017-04-04 04:00	22633,1	1,7
2017-04-04 05:00	22634,9	1,8
2017-04-04 06:00	22636,6	1,7
2017-04-04 07:00	22638,3	1,7
2017-04-04 08:00	22640	1,7

How can obtain this ?

Re: calculated values

beck_bakytbek — Wed, 26 Apr 2017 20:11:42 GMT

Hi Zelazek,

can you give a screenshot of example? what kind of output do you expect?

Re: calculated values

vishsaggi — Wed, 26 Apr 2017 20:17:16 GMT

Try this:

Table1:

LOAD * INLINE [

date, metercounter

2017-04-04 01:00, 22628

2017-04-04 02:00, 22629.7

2017-04-04 03:00, 22631.4

2017-04-04 04:00, 22633.1

2017-04-04 05:00, 22634.9

2017-04-04 06:00, 22636.6

2017-04-04 07:00, 22638.3

2017-04-04 08:00, 22640

];

NoConcatenate

LOAD date,

metercounter,

IF(metercounter - Previous(metercounter) = '', '', metercounter - Previous(metercounter)) AS Diff

Resident

Table1;

Drop Table Table1;

Using Straight table :

Dim:

date

metercounter

Expr:

diff

Re: calculated values

beck_bakytbek — Wed, 26 Apr 2017 20:20:35 GMT

Check this: https://www.youtube.com/watch?v=WwoCepEYrsQ

Re: calculated values

Anil_Babu_Samineni — Thu, 27 Apr 2017 00:39:48 GMT

One Front-End Solution May be this?

Change the Environment ThousandSep from Comma(,) to Dot(.)

Then Try this?

Num(Sum([meter counter]) - Above([meter counter],1),'#,##0.0')

Or Simple do this without change any thing

Replace(Num(Sum(Replace([meter counter],',','.')) - Above(Replace([meter counter],',','.'),1),'#,##0.0'),'.',',')