topic Re: Set Analysis Date range doesn't work when we select a date? in QlikView

Set Analysis Date range doesn't work when we select a date?

Shriram_Sridhar — Wed, 25 Nov 2020 16:16:04 GMT

Hi all,

I have used the below expression to calculate the amount starting from financial year to this date. But, When I try to change the date in the filters, the below expression doesn't work.

For example;

If I select date as 01/05/2017 in the filter, The report should list the values starting from 01/04/2017 to 01/05/2017 but instead it calculates all the values from 01/04/2017 to today.

I have used the below expression in my report;

=Sum({<Dim_Date={'>=$(=YearStart(Max(Dim_Date),0,4)) <=$(=Max(Dim_Date)))'}>}Amount)

What so strange here is when I put the start date in one text box and end date expression in one text box and then I select the date in filters, The dates are changing in the text boxes.

Please help me to fix this issue.

Re: Set Analysis Date range doesn't work when we select a date?

Anil_Babu_Samineni — Fri, 01 Sep 2017 06:04:28 GMT

You must declare the Variable name like

=Sum({<Dim_Date={'>=$(=YearStart(Max(Dim_Date),0,4)) <=$(DateRangeVariableName)'}>}Amount)

=Sum({<Dim_Date={'>=$(=YearStart(Max(Dim_Date),0,4)) <=$(=Max(Dim_Date)))'}>}Amount)

May be one extra parenthesis written

Re: Set Analysis Date range doesn't work when we select a date?

Shriram_Sridhar — Fri, 01 Sep 2017 08:42:19 GMT

Hi Anil,

Thanks for the reply.Again I'm having the same problem. Is there any other simpler way to solve this. The Date inside the expression should change as I change the date in the filters, Also the year function too should work.

Re: Set Analysis Date range doesn't work when we select a date?

Anil_Babu_Samineni — Fri, 01 Sep 2017 08:54:35 GMT

Can you please attach work file to test

Re: Set Analysis Date range doesn't work when we select a date?

Anonymous — Fri, 01 Sep 2017 09:38:34 GMT

Try below one

Sum({$<

Dim_Date={">=$(=MonthStart(AddMonths(Max(Dim_Date),-1)))<$(=MonthEnd(Max(Dim_Date)))"}>}Amount)

Re: Set Analysis Date range doesn't work when we select a date?

sunny_talwar — Fri, 01 Sep 2017 11:36:06 GMT

How about if you use Date() function

=Sum({<Dim_Date = {"$(='>=' & Date(YearStart(Max(Dim_Date), 0, 4), 'DD/MM/YYYY') & '<=' & Date(Max(Dim_Date), 'DD/MM/YYYY'))"}>} Amount)