Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Posting on Qlik Community is temporarily paused for some users. Thank you for patience and we'll update you soon!
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

 

Labels (1)
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