topic Re: Logic on date in QlikView

Logic on date

panipat1990 — Wed, 25 Nov 2020 16:16:04 GMT

Dear Team,

I stuck a requirement.i have two field.ID And Date. For this i am sharing excel.

Case is IN Date column we have More And More Dates.

But i want to only Current month's Min Date.

Suppose Our Current Month is Dec. in date Column we have dec's Month Date is 04/12/2016,06/12/2016,07/12/2016,08/12/2016,10/12/2016.

But i want to date only current's month min date means 04/12/2016. Other Show Null

How is it.Kindly help me.

Re: Logic on date

sunny_talwar — Thu, 29 Dec 2016 12:03:15 GMT

May be this?

Table:

LOAD Article,

GRC_Date

FROM

[..\..\Downloads\Book1.xlsx]

(ooxml, embedded labels, table is Sheet1);

Right Join(Table)

LOAD Article,

Min(GRC_Date) as GRC_Date

Resident Table

Where MonthStart(GRC_Date) = MonthStart(Today())

Group By Article;

Re: Logic on date

parimikittu — Thu, 29 Dec 2016 12:06:09 GMT

Hi Gourav,

Can you please share the desired output as well?

Re: Logic on date

panipat1990 — Thu, 29 Dec 2016 13:26:30 GMT

Dear sunny,

But it showing current month's all dates.but I want to current

month's minimum date .like 01/12/2016....only one date . How is it

Re: Logic on date

sunny_talwar — Thu, 29 Dec 2016 13:28:40 GMT

Try this:

Table:

LOAD Article,

GRC_Date

FROM

[..\..\Downloads\Book1.xlsx]

(ooxml, embedded labels, table is Sheet1);

Right Join(Table)

LOAD Min(GRC_Date) as GRC_Date

Resident Table

Where MonthStart(GRC_Date) = MonthStart(Today());

Re: Logic on date

panipat1990 — Thu, 29 Dec 2016 13:55:33 GMT

It is working . ..but in frontend . .when I create one column of max of GRc_DATE.then

not working . .kindly help me for resolving this issue . ..

I have 2 field date or article . ....but one column is derived max of GRc_DATE in frontend .

another column is derived above your code ....

article max min

1001 10/12/2016 01/11/2016

Re: Logic on date

Thu, 29 Dec 2016 13:57:13 GMT

Hi gourav,

I think

According to sunny,

Table:

LOAD Article,

GRC_Date

FROM

[..\..\Downloads\Book1.xlsx]

(ooxml, embedded labels, table is Sheet1);

Right Join(Table)

LOAD Min(GRC_Date) as GRC_Date

Resident Table

Where MonthStart(GRC_Date) = MonthStart(Today());

This is the correct answer.

so please close the question by selected the sunny reply.

Re: Logic on date

sunny_talwar — Thu, 29 Dec 2016 14:03:16 GMT

Not sure I understand Gourav

Re: Logic on date

panipat1990 — Thu, 29 Dec 2016 15:04:35 GMT

Dear sunny

I have two fields one is article code and second is date . And I want to show in straight table min and max of GRC_DATE ...max date is simply derived max of GRc_DATE ..

but in min date column I required current month's minimum date which are you derived

but in max date column nothing showing . ......so kindly help me for resolving this issue .

Re: Logic on date

panipat1990 — Thu, 29 Dec 2016 15:24:39 GMT

Still waiting

Re: Logic on date

sunny_talwar — Thu, 29 Dec 2016 15:26:20 GMT

I don't know what you want my friend. May be provide an Excel file with your desired output just like parimikittu‌ mentioned

Re: Logic on date

panipat1990 — Thu, 29 Dec 2016 15:52:28 GMT

Dear sunny ji,

I have done it on the behalf of your help ..so I am closing this thread