topic Re: Need help in set analysis in QlikView

Need help in set analysis

sushil353 — Fri, 14 Dec 2012 05:37:47 GMT

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.

Thanks

SKR

Re: Need help in set analysis

sujeetsingh — Fri, 14 Dec 2012 06:08:04 GMT

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

Re: Need help in set analysis

sivarajs — Fri, 14 Dec 2012 07:21:57 GMT

Please find the attachment

Re: Need help in set analysis

Fri, 14 Dec 2012 11:06:58 GMT

Hi,

Please find the attachement,I done your requirement.

Niranjan M.