Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

sushil353
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.

Thanks

SKR

3 Replies
sujeetsingh
Honored Contributor III

Re: Need help in set analysis

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

sivarajs
Valued Contributor II

Re: Need help in set analysis

Please find the attachment

Not applicable

Re: Need help in set analysis

Hi,

Please find the attachement,I done your requirement.

Niranjan M.

Community Browser