9 Replies Latest reply: Jan 30, 2017 5:49 AM by Sunny Talwar

# Date problem in Set Analysis - QLIK SENSE

Hi,

I'm using below calendar in preparing a balance sheet in QLIKSENSE.

Calander:

date(CAL_END_DATE) as CAL_END_DATE,

Date(YearEnd(CAL_END_DATE, 0, 4)) as FiscalDate,

Month(CAL_END_DATE) as Month

Resident Table;

I'm using below two set analysis to display values for the

01. Selected period and

02. Beginning of current financial year as below.

01. CURRENT YEAR

Sum({\$<FiscalDate=,CAL_END_DATE={'=Date(FiscalDate)'}>}YTD)

02.YEAR BEGINNING

Beginning of current financial year ( OR end of last financial year)

My problem is I'm getting the SAME value that I get for the current year for the year beginning as well.

Thanks

Senarath

• ###### Re: Date problem in Set Analysis - QLIK SENSE

Hi Senarath,

as I see is your FiscalDate allready a Date. So you don't need to make It a Date again.

So you can do Sum({\$<FiscalDate=,CAL_END_DATE={'Year(FiscalDate)+1'>}YTD)

KR

Clemens

• ###### Re: Date problem in Set Analysis - QLIK SENSE

Hi Clemens,

Yes correct but I still get the correct answer. Point No.01 is al right and it is working. My problem is I'm getting the same answer for the point number 02 above which should not be the case.

thaks

• ###### Re: Date problem in Set Analysis - QLIK SENSE

Okay, but the syntax is correct?

Maybe its work with something like this:

• ###### Re: Date problem in Set Analysis - QLIK SENSE

Try this..

Sum({<FiscalDate = CAL_END_DATE={'\$(=Date(YearStart(FiscalDate)))'}>}YTD)

• ###### Re: Date problem in Set Analysis - QLIK SENSE

Sorry Guys that also do not work.....

• ###### Re: Date problem in Set Analysis - QLIK SENSE

Is it possible that you can share a qvf file?

So I can check it direktly in the file.

• ###### Re: Date problem in Set Analysis - QLIK SENSE

Did you check the date format in script ?

• ###### Re: Date problem in Set Analysis - QLIK SENSE

01. CURRENT YEAR

Sum({\$<FiscalDate=,CAL_END_DATE={"\$(=Date(FiscalDate))"}>}YTD)

02.YEAR BEGINNING

Beginning of current financial year ( OR end of last financial year)

Dates in Set Analysis

• ###### Re: Date problem in Set Analysis - QLIK SENSE

Try like this

Date(Floor(YearEnd(CAL_END_DATE, 0, 4))) as FiscalDate,

Month(CAL_END_DATE) as Month

Resident Table;

and then this:

01. CURRENT YEAR

Sum({\$<FiscalDate, CAL_END_DATE = {"\$(=Date(Max(FiscalDate)))"}>}YTD)

02.YEAR BEGINNING