Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
Luke_Killer_IT
Creator
Creator

SUM data on 3 WEEK

Hi, 

I would like to sum up the data from 3 weeks. I used such commands: sum ({<KW = {'$ (= Max (KW))'}>} MLA_MMT) but it does not work. HELP 

Luke_Killer_IT_0-1624010440763.png

 

2 Replies
Luke_Killer_IT
Creator
Creator
Author

HI,

I have one more question whether it is possible to create a new column that groups my data as shown in the screen

Luke_Killer_IT_0-1624263243260.png

 

Luke_Killer_IT
Creator
Creator
Author

HI,

okay, I managed to come up with something like this, it's even cool, but you need to refine some ideas to improve it a little so that where there is zero, it does not enter the value in advance.

Luke_Killer_IT_0-1624523201916.png