Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
anushainfy
New Contributor III

Need help on Date Filter

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


6 Replies
vivek_niti
Contributor

Re: Need help on Date Filter

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

anushainfy
New Contributor III

Re: Need help on Date Filter

Thanks for your reply

Quarter field is derived from month field in  backend itself

balkumarchandel
Valued Contributor II

Re: Need help on Date Filter

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

balkumarchandel
Valued Contributor II

Re: Need help on Date Filter

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

anushainfy
New Contributor III

Re: Need help on Date Filter

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

anushainfy
New Contributor III

Re: Need help on Date Filter


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

Community Browser