topic Re: Share Date between 2 Tables in QlikView

Share Date between 2 Tables

wunderch — Wed, 14 Mar 2018 10:09:12 GMT

Hello guys,

I have the following problem:

I have a table with ProjectGroup, Project, Date_from, Date_to, Article, Date_Sales and Sales.

The article-sales can have a project or not.

(see attached qvw)

Now I want to get the sales from article which have a project and the sales from articles who are part of the projects and sold in the time between Date_from and Date_to.

ProjectGroup	min(Date_from)	max(Date_to)	Sales from Article with Project	Sales from Article who are part of a project
1709SPO	01.09.2017	06.09.2017	40	540
1712SPO	01.12.2017	07.12.2017	40	140

How can I get this??

Do I have to load the table 2times with "Article" as Key, but how can I share the Date_from and the Date_to in the second table?

Regards

Christian

Re: Share Date between 2 Tables

sunny_talwar — Wed, 14 Mar 2018 11:43:49 GMT

How can I get this??

What exactly are you trying to get? I am not sure I understand the requirement

Re: Share Date between 2 Tables

wunderch — Wed, 14 Mar 2018 12:51:07 GMT

In Projectgroup 1709SPO I have 2 Projects:

1709FDBSPO with Date_from 02.09.2017 and Date_to 04.09.2017 and Article 123

1709PARSPO with Date_from 01.09.2017 and Date_to 06.09.2017 and Article 456

Now I want 2 columns with all Sales from Article 123:

1. All Sales with Project 1709FDBSPO (Ok, that's not a problem)

2. Alls Sales between Date_from 02.09.2017 and Date_to 04.09.2017 (with or without Project 1709FDBSPO)

I don't know how can I do this?

In qvw I can select 1709FDBSPO, so I get all Sales with this Project, then i can select all Artlices from this Project and deselect the Project. So I get all Sales with Articles who are in this project.

But how can I do this with in formula??