topic Re: Min 3 dates values in QlikView

Min 3 dates values

Wed, 25 Nov 2020 16:16:04 GMT

hi All,

I wanted to take data whose expire date is greater than today().

I use from following code

One:
LOAD [Campaign Id],
[Batch Id],
[Start Date],
[Exp Date]
FROM

(ooxml, embedded labels, table is Sheet1) Where [Exp Date]>Today();

but now I want to show data of 3 expire date of today in pivot or metric. Could anyone explain me how to do it?

do we have any good process than what I did here?

Thanks in adv.

Re: Min 3 dates values

Anil_Babu_Samineni — Wed, 15 Mar 2017 10:53:09 GMT

You can use those Dates as Static in pivot expression

Sum({<[Exp Date = {'Date1','Date2','Date3'}]>}Sales)

Re: Min 3 dates values

sunny_talwar — Wed, 15 Mar 2017 10:55:31 GMT

now I want to show data of 3 expire date of today in pivot or metric.

3 expire date of today? What do you mean? Do you mean the campaign id which is within 3 days from today?

Re: Min 3 dates values

adamdavi3s — Wed, 15 Mar 2017 10:58:11 GMT

Do you mean this?

count({<[Exp Date] = {"<=$(=date(today()-3))"}>}Campaign Id)

Re: Min 3 dates values

sunny_talwar — Wed, 15 Mar 2017 10:59:26 GMT

Adam I think there is a typo in your and Anil's expression

Sum({<[Exp Date = {"<=$(=date(today()-3))"}]>}Sales)

Should be this

Sum({<[Exp Date] = {"<=$(=date(today()-3))"}>}Sales)

Re: Min 3 dates values

adamdavi3s — Wed, 15 Mar 2017 11:00:42 GMT

sorry typing too quick, corrected it

Re: Min 3 dates values

Wed, 15 Mar 2017 11:17:22 GMT

I have data after reload

Batch Id	Campaign Id	Start Date	Exp Date
212	817171	14/03/2023	14/02/2024
217	896343	17/08/2020	17/07/2021
226	845697	30/09/2019	30/08/2020
239	848442	05/12/2023	05/11/2024
241	874978	14/04/2022	14/03/2023

I want answer

Batch Id	Campaign Id	Start Date	Exp Date
226	845697	30/09/2019	30/08/2020
217	896343	17/08/2020	17/07/2021
241	874978	14/04/2022	14/03/2023

Re: Min 3 dates values

sunny_talwar — Wed, 15 Mar 2017 11:21:28 GMT

May be like this

Dimension

Batch Id

Campaign Id

Exp Date

Expression

Date(Only({<[Start Date] = {"$(='<=' & Date(Min([Start Date], 3), 'DD/MM/YYYY'))"}>} [Start Date]))

Updated the expression and attached a sample

Re: Min 3 dates values

Wed, 15 Mar 2017 12:11:31 GMT

Thanks all of you ...