topic Re: How to find the date difference values in QlikView

How to find the date difference values

ravindraa — Thu, 06 Nov 2014 14:00:39 GMT

Hi all ,

i have struck one place please help me to get solution.

My requierment is officer enter his present on dily basis some time he take lave , in my app i have to caliculate how many day perticular officer take laeve what are those days and based on the FROMDATE to TODATE.

1.how many days officer present

2.how many days offcer take leave

3.how many days he didnot punch (Null value) .

above caliculation i have to show one chart i have wrote one logic but It is not selecting FROM DATE AND TODATE selction as well as i t is not givine the in the list of presented dates , leave date.

please give me suggeson on this.

Please find the attachments.

Thanks in advance...,

Re: How to find the date difference values

MK_QSL — Thu, 06 Nov 2014 14:34:38 GMT

Check the enclosed file...

Re: How to find the date difference values

ravindraa — Fri, 07 Nov 2014 02:47:28 GMT

Hi Manish Kachhia,

Thanks for replying but the values are not reflecting based on the dates selection (min date and max date) the values has to display based on the selection wise, could you give me any suggesion on this.

Thaks in advance..

Re: How to find the date difference values

ravindraa — Fri, 07 Nov 2014 05:39:50 GMT

Hi,

experts please help me on this issue,