How to get data from 1st of april 2017 to 7th of july 2017

[qlikcheepirishe]

My database is in oracle and my user requirement is like he want report to be generated from Fiscal year start that is 1st April '17 to 7th July '17.

I have straight table in which data is displayed how to get the report for the user requirement as I mention above.

Can anyone share the expression for the following

[Anil_Babu_Samineni]

Here is the answer Fiscal Year

[qlikcheepirishe]

I want the result in chart instead affecting my data model in script

[Anil_Babu_Samineni]

please provide sample data set and explain the result set you want to show with some selection. That may useful

[Frank_Hartmann]

try like below:

sum({<Date={"=Date>=date#('2017.04.01','YYYY.MM.DD') and Date<=date#('2017.07.07','YYYY.MM.DD') "}>} Value)

hope this helps

[sergio0592]

Try with :

=sum({<Date_field={">=$(=YearStart(max(Date_field),0,4))"  <=$(=Max(Date_field))"}>}   Indicator)

[Kushal_Chawda]

try below expression

sum({<DateField ={">=$(=yearstart(max(DateField),0,4))<=$(=max(DateField))"}>} Sales)

[qlikcheepirishe]

I have expression like reload-1

[sergio0592]

What are the name of the following fields recovered in QlikView from your Oracle DB :

-Your indicator, the fact.

-Yout date field

[Anonymous]

Easiest way would be to add a Fiscal Year field in your data model.

Then the user can select which Fiscal Year they want to look at.  Or you can have the chart default to most recent fiscal year with something like max([Fiscal Year]).

If you only ever care about the current fiscal year you can add a field in your data model like

if(yearstart(Date_field,0,4)=yearstart(today(),0,4),1,0) as CurrentFiscalYrFlag

Then in you can just multiple your expression by the flag.

For instance in your chart it would be something like, sum(Sales) * CurrentFiscalYrFlag

You could also use set analysis like  Sum({<CurrentFiscalYrFlag={'1'}>}Sales