topic Re: Dates in QlikView

Dates

nareshthavidishetty — Tue, 01 Sep 2015 05:24:38 GMT

Hi,

My date contains up to 8/17/2015 when i checked with listbox.

But i need to show show the report like this,and from 8/18/2015 it would be null values.

Re: Dates

sunny_talwar — Tue, 01 Sep 2015 05:26:34 GMT

You will need to create a Master Calendar in the script to have them available in the list box. Look here for the Master Calendar: Creating A Master Calendar

HTH

Best,

Sunny

Re: Dates

nareshthavidishetty — Tue, 01 Sep 2015 06:02:23 GMT

I need report like as per second image.

Re: Dates

sunny_talwar — Tue, 01 Sep 2015 06:04:58 GMT

That is possible only if you have those dates in the application. We can show you how it can be done if you can share some sample data in Excel format (Instead of the image)

Best,

Sunny

Re: Dates

engishfaque — Tue, 01 Sep 2015 06:16:32 GMT

Dear Naresh,

Please add listed below statement in your load script,

if(myDateField > '8/18/2015', null(), myDateField) as myDateField //you can write variable name instead of 8/18/2015

Kind regards,

Ishfaque Ahmed

Re: Dates

sunny_talwar — Tue, 01 Sep 2015 06:23:48 GMT

This?

Script:

Table:

LOAD Date,

Value

FROM

Community_178604.xlsx

(ooxml, embedded labels, table is Sheet1);

Temp:

Load Min(Date) as minDate,

Max(MonthEnd(Date)) as maxDate

Resident Table;

Let varMinDate = Num(Peek('minDate', 0, 'Temp'));

Let varMaxDate = Num(Peek('maxDate', 0, 'Temp'));

DROP Table Temp;

TempCalendar:

LOAD Date($(varMinDate) + IterNo() - 1) as Date

AutoGenerate 1

While $(varMinDate) + IterNo() -1 <= $(varMaxDate);

Straight Table:

Dimension: Date

Expression: Sum(Value)

On the Presentation tab uncheck 'Suppress Zero Values'

Re: Dates

nareshthavidishetty — Tue, 01 Sep 2015 09:01:15 GMT

Thank you sunny its working fine.

Re: Dates

sunny_talwar — Tue, 01 Sep 2015 09:02:15 GMT

Awesome

I am glad it worked.

Best,

Sunny