Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Here is the answer Fiscal Year
I want the result in chart instead affecting my data model in script
please provide sample data set and explain the result set you want to show with some selection. That may useful
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
Try with :
=sum({<Date_field={">=$(=YearStart(max(Date_field),0,4))" <=$(=Max(Date_field))"}>} Indicator)
try below expression
sum({<DateField ={">=$(=yearstart(max(DateField),0,4))<=$(=max(DateField))"}>} Sales)
I have expression like reload-1
What are the name of the following fields recovered in QlikView from your Oracle DB :
-Your indicator, the fact.
-Yout date field
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