Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
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