topic Re: rolling count(date beetween count ) in QlikView

rolling count(date beetween count )

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

how i get between dates count of days

Re: rolling count(date beetween count )

Anil_Babu_Samineni — Tue, 23 Jan 2018 00:04:18 GMT

I am replying from mobile so i haven't seen your attachment

May be

Date1-date2

Internal also helps here

Re: rolling count(date beetween count )

Shiva123 — Tue, 23 Jan 2018 00:04:58 GMT

hey ,

rama can u explain a little more about the issue you are facing ?

Re: rolling count(date beetween count )

ramakrishnaraavi — Tue, 23 Jan 2018 01:16:49 GMT

hi,

i have two years dates like 15/10/17,18/10/17,22/10/17 ,25/10/17,29/10/17,2/11/17,5/11/17

i want all dates between count of days

every excutive every sale how many days they will take

Re: rolling count(date beetween count )

shiveshsingh — Tue, 23 Jan 2018 06:49:11 GMT

may be this..

LET vMinDate=NUM(YearStart(AddYears(TODAY(),-2)));
LET vMaxDate=NUM((TODAY()));

Date:LOAD [Row ID],
[Order ID],
[Order Date] as Date,
[Order Priority],
[Order Quantity],
Sales,
[Sales Target],
Discount,
[Ship Mode],
Profit,
[Unit Price],
[Shipping Cost],
[Customer Name],
Province,
Region,
[Customer Segment],
[Product Category],
[Product Sub-Category],
[Product Name],
[Product Container],
[Product Base Margin],
[Ship Date]
FROM

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

NoConcatenate
Calender:
Load
Date($(vMinDate)+RowNo()-1,'DD-MMM-YYYY') AS Date
AutoGenerate
$(vMaxDate)-$(vMinDate)+1;

Re: rolling count(date beetween count )

pradosh_thakur — Tue, 23 Jan 2018 08:46:48 GMT

May be this

LOAD [Row ID],

[Order ID],

[Order Date],

[Order Priority],

[Order Quantity],

Sales,

[Sales Target],

Discount,

[Ship Mode],

Profit,

[Unit Price],

[Shipping Cost],

[Customer Name],

Province,

Region,

[Customer Segment],

[Product Category],

[Product Sub-Category],

[Product Name],

[Product Container],

[Product Base Margin],

[Ship Date],

[Ship Date]-[Order Date] as count_days

FROM

[Sample - Superstore Sales (Excel).xls]

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

Re: rolling count(date beetween count )

sasikanth — Tue, 23 Jan 2018 10:21:11 GMT

HI RAMA,

Sample script

Load

Executive,

Order_Date,

IF(Executive=Above(Executive), Order_Date-Above(Order_Date) , Order_Date) as NoOfDaysForAnOrder

FROM SALES

Order by Order_Date Asc

If not please share your application, attached is a sample file i think.