Discussion Board for collaboration related to QlikView App Development.
I have a fiscal quarter starts from Oct to Sep.
Q1-Oct to Dec
Q2-Jan to Mar
Q3-Apr to Jun
Q4-Jul to Sep.
As per user requirement in dashboard I have to show last fiscal QTD .For E.g,
Now It should show Q3-Apr to jun till Sep.In jun it should show Jan To Mar.
How to set these in Textbox with the hep of set analysis or variables.
Please guide me.
Try to adjust this expression to your needs.
'Q' & if(Ceil(Month(YourDate)/3)=4,1,Ceil(Month(YourDate)/3)+1)&'-' & quartername(YourDate )
To calculate someone within this quarter adjust this expression.=dayname(quarterstart(MAX(YourDate), -1))) <$(=dayname(quarterstart(MAX(YourDate))))"}>}Quantity)
If you want the expressions to calculate todays last quarter you replace YourDate with Today()
If you want the expressions to calculate last quarter for the highest date in your selection you replace YourDate with $(=max(Date field))
It is not working.Can you give example with sol.