How to group by month wise data in qlikview script... I have grouped the data by month wise but I didn't get it exactly. In my data I have multiple records for a single date, but I want all these dates to be included instead of making it as a single data. so, please anyone give an idea to do this.
it should work ...try like this
Monthname(floor(sheet_date)) as Month_Year
sum(value) as Sum_Value,
If its not working could share the error details or the sample output your looking for ??