Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Live chat with experts, bring your API Integration questions. June 15th, 10 AM ET. REGISTER TODAY
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