Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

column display only the 1st value of the month group by store

Hi, I currently have this table:

DateStoreValue
1-JunA4
2-JunA2
3-JunA7
4-JunA3
5-JunA5
1-JunB9
2-JunB3
3-JunB4
4-JunB4
5-JunB8
1-JunC6
2-JunC3
3-JunC9
4-JunC5
5-JunC2

How can I have the 'Value' column to take the 1st day of the month value?:

StoreValue
A4
B9
C6

Thanks.

0 Replies