Skip to main content
Announcements
See why Qlik is a Leader in the 2024 Gartner® Magic Quadrant™ for Analytics & BI Platforms. Download Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

total in staright table

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

 

datenew_column
Jan 1, 2016459.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

1 Solution

Accepted Solutions
antoniotiman
Master III
Master III

Script

Load * from Table;

Chart:

Dimension : Date

Expression : Sum(identity*time*0.3)

View solution in original post

4 Replies
antoniotiman
Master III
Master III

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
;

or

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

Resident Temp

Group By date;

Drop Table Temp;

Regards,

Antonio

Not applicable
Author

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
Master III
Master III

Script

Load * from Table;

Chart:

Dimension : Date

Expression : Sum(identity*time*0.3)

Not applicable
Author

Thank you so much Antonio