Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

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.