https://community.qlik.com/thread/316205
Use DATE#,Left functions. Search in Qlikview Help
Data:
Name | Date | Sales |
Modi | 07/10/2018 12:00:00 AM | 9 |
Babu | 11/09/2018 12:00:00 AM | 3 |
Name3 | 20/07/2018 12:00:00 AM | 5 |
Name1 | 20/09/2018 12:00:00 AM | 0 |
Name2 | 21/08/2018 12:00:00 AM | 0 |
Ramesh | 21/08/2018 12:00:00 AM | 2 |
John Saida | 30/09/2018 12:00:00 AM | 3 |
Gopi Raju | 31/08/2018 12:00:00 AM | 2 |
Check this thread:
https://community.qlik.com/thread/315995
Data:
LOAD * INLINE [
Name,Date,Sales
Gopi Raju,31/08/2018 12:00:00 AM,2
John Saida,30/09/2018 12:00:00 AM,3
Ramesh,21/08/2018 12:00:00 AM,2
Name1,20/09/2018 12:00:00 AM,0
Name2,21/08/2018 12:00:00 AM,0
Name3,20/07/2018 12:00:00 AM,5
Babu,11/09/2018 12:00:00 AM,3
Modi,07/10/2018 12:00:00 AM,9
];
Advertisements