topic Re: Date Function Issue in QlikView

Date Function Issue

xavieravinson — Sat, 06 Dec 2014 11:14:00 GMT

Hello All

I am facing a date problem in my application.

I have to use cycle end dates. for each cycle i have to use max of end date. for selection

of cycle the values are coming correct. if i am using a pivot table to view all the cycles

it will always takes the max of cycle end date.

please provide me a solution for the above issue.

Thank you all.

MK_QSL — Sat, 06 Dec 2014 11:15:17 GMT

Kindly provide some sample data to work on your issue...

Thanks

xavieravinson — Sat, 06 Dec 2014 11:24:53 GMT

My cycle starting from april

for cycle 1 apr 1st is my start date and 27 is my cycle end date

for cycle 2 28 apr is my start date and 25 may is cycle end date like wise

i have to show the onroll on employees which are falling in cycles

vivek_niti — Sat, 06 Dec 2014 11:48:58 GMT

Hi,

Create cycles in the calendar and then plot the data against the cycle dimension.

Dimension : Cycle

Measure: Count(DISTINCT Employee)

Regards,

Vivek

MarcoWedel — Sat, 06 Dec 2014 12:21:16 GMT

Please create a sample app including sample date.