Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Honored Contributor II

Need help in set analysis

Hi All,

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.



3 Replies
Honored Contributor III

Re: Need help in set analysis

just take master calender and then take max of monthday in set analysis...

Valued Contributor II

Re: Need help in set analysis

Please find the attachment

Not applicable

Re: Need help in set analysis


Please find the attachement,I done your requirement.

Niranjan M.

Community Browser