Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

Quater End

I want sales  wrt finicial year only for which quater has ended.Example

For year 2012-13 my three quater is completed i.e q1,q2,q3 so my sales should come but for q4 only two mnths is compeletd so no data should come for q4 of 2012-13.

Please help me out...

9 Replies
Not applicable

Re: Quater End

I propose to  move the relevant data to a new table by using QuarterStart and QuarterEnd in a where-clause:

NewTable:

LOAD

     Date as MaxLastQ_Date,
     Sale as MaxLastQ_Sale
FROM quarter_input.xls
(
biff, embedded labels, table is Sheet1$)
WHERE QuarterEnd(Date) < QuarterStart(Today());

Regards,

sebablum

Vegar
Not applicable

Re: Quater End

I'll would look for which quarter  tomorrows date fall under and then exclude it.

Example1: My last transaction data is from 2012-12-31 (q4 2012), the day after is 2013-01-01 (q1 2013). I will only include Quarters < q1 2013 

Example2:  My last transaction data is from 2012-12-15 (q4 2012), the day after is 2013-12-16 (q4 2012). I will only include Quarters < q4 2012. 

Please ekskuse my Norglish and Swenglish typos.
Not applicable

Re: Quater End

@sebablum

i want this condition to be applied on the front end where i want to see data on the basis of finicial year and quarter

Vegar
Not applicable

Re: Quater End

Then I would have implemented a calendar with a Quarter index of some kind.

sum({<_QuarterSerial={"<$(=max(_QuarterSerial))"}>}Sale)

Please ekskuse my Norglish and Swenglish typos.
Not applicable

Re: Quater End

@Vegar Arntsen, Lie

Can u tell me how u have calculated _QuarterSerial. And If possible please provide me the .qvs file that u have included in an application

Not applicable

Re: Quater End

hi

try this code

LOAD date,

     Sale

FROM

D:\test35.xls

(biff, embedded labels, table is Sheet1$);

LOAD *,

Day(date) as day,

Month(date) as month,

Year(date) as year,

yearname(date,0,4) as FinancialYear;

LOAD

date(Date#(date,'DD.MM.YYYY')) as date, 

      Sale

FROM

D:\test35.xls

(biff, embedded labels, table is Sheet1$);  .

Not applicable

Re: Quater End

@Vegar Arntsen, Lie

Ur code runs perfectly but my finicial begin from april 2011 to mar 2012. thats why i need ur qvs file so that i changed year format

Not applicable

Re: Quater End

@Vegar Arntsen, Lie

Please provide me ur Qvs file..

Vegar
Not applicable

Re: Quater End

It is the QlikView Components code library.

You find it at http://qlikviewcomponents.org

Please ekskuse my Norglish and Swenglish typos.