topic regarding date range selection in QlikView

regarding date range selection

sushil353 — Thu, 25 Aug 2011 11:45:54 GMT

Hi ALL,

I want to give functionality in my dashboard to enter date range manually..

So for that i created two variable vStartDate and vEndDate

in my time dimension table i have field TIME_DATE in 24/07/2011 12:00:00 AM format...

I created two calender object to enter the value with min value as =Min( {1} TIME_DATE) and max value as =Max( {1} TIME_DATE)

and in my chart i applied condition as Sum ({<TIME_DATE={">=$(vStart)<=$(vEnd)"}>} TOTAL_DEFECTS))

But i am not getting results... when i checked the variable value, it is found to be 48750.93333...

Please help me out to find out that wt mistake i did in this...

Thanks...

regarding date range selection

kaushiknsolanki — Thu, 25 Aug 2011 11:52:56 GMT

Hi,

Its because your Field contains data in DateTime format and your variable is holding data in Date format.

So according to qlikview they are not same and thus you cant see the filtered data.

Change the field to DATE from script and create a same field which contains only date.

Date(TIME_DATE) as T_DATE

And use this T_DATE in your set analysis to filterdata.

Regards,

Kaushik Solanki

regarding date range selection

sushil353 — Thu, 25 Aug 2011 12:01:16 GMT

Thanks Kaushik,

But i am using TIME_DATE field in other charts where this date time property is used...

how to solve it in another way..

Thanks

regarding date range selection

kaushiknsolanki — Thu, 25 Aug 2011 12:05:20 GMT

HI,

I am not saying you to remove the field. I said Create a new field which holds only date and use that field in chart in set analysis.

Regards,

Kaushik Solanki

regarding date range selection

its_anandrjs — Thu, 25 Aug 2011 12:16:13 GMT

Hi,

Do you share any sample file for this as you say it is not difficult it is looks easy check your date field once again it is correcr or not.

Can you share any sample file.

Regards,

Anand

regarding date range selection

Thu, 25 Aug 2011 13:10:23 GMT

I think Kaushik Solanki has the more elegant solution, but you could perhaps try adding the date() code to your Set Analysis filter/modifier (to keep from adding a new field via script). For example:

Sum ({<TIME_DATE={'>=$(=date($(vStart),"MM/DD/YY"))<=$(=date($(vEnd),"MM/DD/YY"))'}>} TOTAL_DEFECTS))

Obviously you can use another date format if needed.