topic Re: Sales difference between two dates in QlikView

Sales difference between two dates

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

Hello,

Guys I have date data,Need to find difference between two selection date .

Ex: 1/1/2015 till 1/12/2015

Need to find Sales between,if date 1/1/2015 to 1/5/2015 range sales.Without using set analysis.

I upload excel data.

Please help.

Re: Sales difference between two dates

prma7799 — Wed, 07 Jun 2017 07:15:46 GMT

Use calendar object for this

Slider/Calendar Object ‒ QlikView

Selecting Arbitrary Date Ranges

Re: Sales difference between two dates

Anonymous — Wed, 07 Jun 2017 07:20:21 GMT

Thanks for reply,

But i already search this post,Please Using variable function maxdate and mindate.

Thanks

Re: Sales difference between two dates

Anonymous — Wed, 07 Jun 2017 07:41:51 GMT

Hi Aniket,

Please let me know what exactly you want to do.

Firstly, I see the raw data has different Date formats. Please use the below expression to correct this.

Date(alt(Date(Date),MakeDate(SubField(Date,'/',3),SubField(Date,'/',2),SubField(Date,'/',1)))) as Date

Re: Sales difference between two dates

Anonymous — Wed, 07 Jun 2017 07:48:20 GMT

I have just given simple date excel sheet, which contain Date 1/1/2015 to 9/7/2017.

My question is, If i select date between 1/1/2015 till 1/5/2015, So date will show sales of between these date range.

Condition: Using maxdate and mindate function (Variable)

I hope explain it clear.

Thanks

Re: Sales difference between two dates

Anonymous — Wed, 07 Jun 2017 07:54:59 GMT

If you convert the dates to the correct format, and add these into a listbox you will get the desired result by just selecting the relevant dates, and creating an expression SUM(Sales)

Does this answer your question? If you want Max and Min Dates you will have to do the changes in the script.

Re: Sales difference between two dates

prma7799 — Wed, 07 Jun 2017 07:59:12 GMT

Like this ??

Please select calendar to find the sale

Re: Sales difference between two dates

Anonymous — Wed, 07 Jun 2017 08:00:11 GMT

Thanks Ruan,

It is the correct answer,But how you get this.

Please send me how it works.

Re: Sales difference between two dates

Anonymous — Wed, 07 Jun 2017 08:02:09 GMT

How its works on Back end.

Thanks,

Re: Sales difference between two dates

Anonymous — Wed, 07 Jun 2017 08:09:54 GMT

Copy the below Script:

LOAD Country, Date(alt(Date(Date),MakeDate(SubField(Date,'/',3),SubField(Date,'/',2),SubField(Date,'/',1)))) as Date, Sales

FROM [..\..\Date sample.xls] (biff, embedded labels, table is Sheet1$);

Just change your path.

And on the frontend , add Country and Date in Listboxes and make your selections.

Hope this helps. Please mark as helpful or correct if it works for you.

Re: Sales difference between two dates

Anonymous — Wed, 07 Jun 2017 11:05:30 GMT

By using where condition,comparative analysis using variable.

I tried by group by condition but not getting it

Ex:. The date will be 1/1/2015 to 1/5/2015 till sales .

Thanks