topic Re: total in staright table in QlikView

total in staright table

Sun, 09 Oct 2016 13:50:20 GMT

Hi i have the below data

id identiy date time

1. 1 Jan 1, 2016 0.02201673

2. 3 Jan 1, 2016 0.01105705

3. 27 Jan 1, 2016 0.02656042

4. 1 Jan 1, 2016 0.26666667

5. 175 Jan 1, 2016 0.51282051

6. 144 Jan 1, 2016 10

and my output should be like this

date	new_column
Jan 1, 2016	459.234

the new_column formula is for every row it should calculate (identiy * time* 0.3 )

and sum up every row to get the new_column output

Regards

antoniotiman — Sun, 09 Oct 2016 14:15:20 GMT

Hi John,

may be

Temp:

LOAD * From Table;

Left Join
Load date,Sum(identity*time*0.3) as new_column
Resident Temp
Group By date;

Load date,Sum(identity*time*0.3) as new_column

Resident Temp

Group By date;

Drop Table Temp;

Regards,

Antonio

Sun, 09 Oct 2016 14:19:59 GMT

Hi Antonio, can we do it in set analysis, i'm worried if some of the filters wont work if i do a calcul;ation in the back end.

antoniotiman — Sun, 09 Oct 2016 14:27:24 GMT

Script

Load * from Table;

Chart:

Dimension : Date

Expression : Sum(identity*time*0.3)

Sun, 09 Oct 2016 14:45:02 GMT

Thank you so much Antonio