topic Re: two dates issue in QlikView

two dates issue

Anonymous — Tue, 10 May 2016 10:06:08 GMT

Hi all,

i have two tables and a master calendar

table1:

Orderdate

Orderdate as date

Sales

Tables:

Deliverydate

Deliverydate as date

Now, the above two tables are linked with a common field. i have created a master calendar with the date field from those two tables.

My requirement is , when i select a range of dates from deliverydate i need the sum of sales for that range of dates in the orderdate.

For example:

if i select a range in date (1st jan 2016 to 5th jan 2016) then,

the deliver date range should be 1st jan 2016 to 5th jan 2016 and order date also should be between 1st jan 2016 to 5th jan 2016 . so that i can sum the sale based on the order date .

advance thanks

thanks,

anusha

Re: two dates issue

MK_QSL — Tue, 10 May 2016 10:13:11 GMT

Canonical Date

Re: two dates issue

Tue, 10 May 2016 10:24:53 GMT

Hi,

You can also use Flag to differentiate two different tables and use Flag='Order' while calculating sum(Sales) from order table.

Re: two dates issue

Anonymous — Tue, 10 May 2016 10:27:05 GMT

i have given a scenario out of my requirement. But in my dashboard i am using 10 dates fields from 5 different tables and are joined to master calendar.

Kindly help me out for my requirement posted.

Re: two dates issue

Uday_Pasupuleti — Tue, 10 May 2016 10:35:43 GMT

1.Create a seperate Master calender(Data Island) without any association.

2.Creat 2 variables with min and max dates from the calender.

3. In the script use sum({<Orderdate={'>=$(vMinDate)<=$(vMaxDate)'}>}sales)

or you can use sum({<Orderdate=P(Date}>}sales)

Re: two dates issue

MK_QSL — Tue, 10 May 2016 10:36:52 GMT

Provide proper sample data or sample application..!

Re: two dates issue

Anonymous — Thu, 12 May 2016 02:39:08 GMT

PPlease help on ‌based on other date

Re: two dates issue

Uday_Pasupuleti — Thu, 12 May 2016 08:19:25 GMT

Did you try the expression provided by Avinash R?

It should work by the looks of it.