topic Re: Need help on Date Filter in QlikView

Need help on Date Filter

Anonymous — Fri, 26 Jun 2015 06:15:48 GMT

Hi Team,

Hope all are doing good.

I need help on date filter.

Actually I have time filters like Year,Quarter and MOnth.

The issue is if I select any year and followed by any quarter the data is filtering and displaying on dashboard.

But the main issue is coming when I change the quarter filter selection the data is not filtering instead the selections are clearing..

.This issue could be due to Quarter is derived from Month.I think we can derive Quarter directly based on user selections on the Fly instead of getting it from DM .How to do this.

Thanks In advance

Best Regards

Anusha K

Re: Need help on Date Filter

vivek_niti — Fri, 26 Jun 2015 06:23:38 GMT

Hi,

Instead of creating the quarters at the front end, I would suggest you to create a separate calendar and then link the calendar with the transactions.

Regards,

Vivek

Re: Need help on Date Filter

Anonymous — Fri, 26 Jun 2015 06:26:58 GMT

Thanks for your reply

Quarter field is derived from month field in backend itself

Re: Need help on Date Filter

Anonymous — Fri, 26 Jun 2015 06:34:35 GMT

Hi Anusha have you used same datecolumn to calulate Year,Qtr,Month ?

can you share the YEAR ,QTR ,Month calculation part from your script

Thanks

BKC

Re: Need help on Date Filter

Anonymous — Fri, 26 Jun 2015 06:46:28 GMT

use below code to calculate the Year, QTR and Month

LOAD DISTINCT

Year(Temp_Date) * 100 + Month(Temp_Date) as [Period],

Year(Temp_Date) as [Year],

Month(Temp_Date) as [Month],

Date(Temp_Date, 'YYYY-MM') as [Year - Month],

'Q' & Ceil(Month(Temp_Date) / 3) as [Quarter]

;

Thanks

BKC

Re: Need help on Date Filter

Anonymous — Fri, 26 Jun 2015 06:48:37 GMT

Hi BalKumar,

we are getting the fields like this

[Payment Date] as Prod_Date,

Year([ Payment Date]) as Year,

Month([Payment Date]) as Month,

if(IsNull([Payment Date]) = 0, 'Q'& Ceil(Month([Payment Date])/3)) As Quarter

Re: Need help on Date Filter

Anonymous — Fri, 26 Jun 2015 08:19:59 GMT

Hi Balkumar I am also used same logic but not getting result