Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Highlighted
rupaliqlik
Contributor

Want to show last Fiscal QTD in Textbox

Hi Folks,

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.

sunny t

 

Thanks,

Rupali Ethape

 

Tags (1)
4 Replies
Partner
Partner

Re: Want to show last Fiscal QTD in Textbox

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))

Plees ekskuse my Swenglish and or Norweglish spelling misstakes
rupaliqlik
Contributor

Re: Want to show last Fiscal QTD in Textbox

It is not working.Can you give example with sol.

Partner
Partner

Re: Want to show last Fiscal QTD in Textbox

I'm sorry, I'm not familiar with the term "sol".
Plees ekskuse my Swenglish and or Norweglish spelling misstakes
rupaliqlik
Contributor

Re: Want to show last Fiscal QTD in Textbox

  • Q2 the [Sales] column will show sales for Q2 and [Previous QTR Sales] Shows Q1 sales
  • Q3 the [Sales] column will show sales for Q2 and [Previous QTR Sales] Shows Q2 sales
  • Q4 the [Sales] column will show sales for Q2 and [Previous QTR Sales] Shows Q3 sales