Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Sum function in qlik

Hello every body! for example  i have this data.

now i want to take data this day and data of 7 days ago. what can i do with qlik sense.

Capture.PNG

if i choose date in filter pane is 07/01/2015 i have report like this:

Capture.PNG

3 Replies
Gysbert_Wassenaar

Perhaps like this =sum({<DATE={<$(=Date(Only(DATE)-7,'MM/DD/YYYY'))>}>}AMOUMT)


talk is cheap, supply exceeds demand
Anonymous
Not applicable
Author

Hi

if you would like to have all the sum from last 7 days

in Expression :

=Sum({<DATE = {">=$(=Date(Today()-6,'MM/DD/YYYY'))<=$(=Date(Today(),'MM/DD/YYYY'))"}} Amount)




if you would like to have Only on  7 days ago.



=Sum({<DATE = {"$(=Date(Today()-6,'MM/DD/YYYY'))"}} Amount)

Not applicable
Author

so If 2 have 2 table: i need to calculated 2 amounts, amount_1 + amount_2. Which calculation can i use? please help me.

Thank so much