Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I need to pick up all transactions within the current Financial Year that are not blank. i have the following formula but it is not working (no error just zero shows up). A little red line shows up under the "}" after FiscalYear.
if(ContactOptions <> '',Count({<%DateEmpFormAdded = FiscalYear>}) EngagementType)
Any assistance appreciated.
Also can anyone direct me to a youtube or page where it explains the use of the following characters in a formula?
}
]
,
etc....
This is a good pdf file to learn about set analysis syntax.
Also some other good links:
http://tools.qlikblog.at/SetAnalysisWizard/QlikView-SetAnalysis_Wizard_and_Generator.aspx?sa=_CNGH
This is a good pdf file to learn about set analysis syntax.
Also some other good links:
http://tools.qlikblog.at/SetAnalysisWizard/QlikView-SetAnalysis_Wizard_and_Generator.aspx?sa=_CNGH
thanks Sunny.
for "today", i can write today(). is there the same for month?
No.
Today is a function on itself
Today() will be always ..today.
Month needs an argument.
to example
Month(Today) will return May
thanks Robert,
ok, so that is what i used here. I dont understand where i am going wrong then? i dont recive and error but no data displays. you cant see it here but in the Expression the Date{ is underlined in Red
if(ContactOptions <> '',Count( {$<Date{"%DateEmpFormAdded = Month(Today())"}>} EngagementType))
If(ContactOptions <> '', Count({$<%DateEmpFormAdded = {"$(=Month(Today()))"}>} EngagementType)
Simple SA syntax:
Outer { } - delimits the entire set analysis clause
$ - the set on which to operate - $ means current selections and can be omitted
< > - the qualifier for the set
field = {...} - the qualifier expression, the LHS is field name only, the RHS is a list of possible values (with single quotes) or a search term (with double quotes). You can have multiple expressions, separated by commas.
thank-you Jonathan.
i do not recieve any results back nor an error. i think it may have something to do with date format?
So what i tried was adding a variable:-
//LET vMonth_Current = Month(Today(),'MM');
i reran teh script and it wouldnt even reload the data.
What format has your
DateEmpFormAdde
dimension?
Could you post a sample?
EngagementType | %DateEmpFormAdded | FiscalMonthYear | FiscalMonthNumber | DateEmpMonth |
Career | 20/10/2015 | Oct-2015 | 4 | Oct |
Career | 23/10/2015 | Oct-2015 | 4 | Oct |
Hi,
How do you calculate Fiscal Year?
When you compare from Fiscal Year start to today with date. Then you need provide range in set analysis.
Try like
If(ContactOptions <> '', Count({$<%DateEmpFormAdded = {">=01/04/2016<=$(=Date(Today()))"}>} EngagementType)
Since above expression is hard coded for Fiscal Year Start date you can make it dynamic also.
Kind Regards