Discussion Board for collaboration on QlikView Layout & Visualizations.
In my application i need to get count of data for the lastday of the selected month.
i have a Date field which contains Date with time stamp. i have taken that Date field in listbox and there i have set an expression "=monthname(Date)" to get only month name in the list box.
Now if i select Oct 2012, i should get count of DATA for 31-Oct-2012 in the chart. in my sample data it should be 39.
i have attached the sample application and sample data file for clear understanding.
Please help me out to solve this problem.
just take master calender and then take max of monthday in set analysis...
Please find the attachment
Please find the attachement,I done your requirement.