Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Highlighted
hazar_sanlier
New Contributor II

aggr(),rank(),if()

 

Hi all:),

I have a problem  could you  help to me please.

I have 3 columns(Date,Hours,Count(I3) )
 
how can i take sum of up to this hour yesterday?
How do I get 50 value?

 

thank you so much..

Date ,hours, Count(I3), target 
2019.02.15, 13, 20, 50 (Now)
2019.02.15, 12, 19,  
2019.02.15, 11, 17,  
2019.02.15, 10, 16,  
2019.02.15, 9, 15,  
2019.02.14, 17, 55,  
2019.02.14, 16, 26,  
2019.02.14, 15, 15,  
2019.02.14, 14 45,  
2019.02.14, 13, 10, 50 
2019.02.14, 12, 10,  
2019.02.14, 11, 10,  
2019.02.14, 10, 10,  
2019.02.14, 9, 10,  

 

 

Labels (3)
1 Reply
Support
Support

Re: aggr(),rank(),if()

What is the logic that should be used to calculate the sum?
Do you need it calculates in the script or it could be calculated in the visualization layer?


To help users find verified answers, please don't forget to mark a correct resolution or answer to your problem or question as correct.