Filter values from one column based on values from other two columns

Wed, 29 May 2013 07:39:07 GMT

Hi to All,

I have two tables:

One containing the day bay day sales:

ID	Client	Date	Sales
1	Name1	1/15/2013	50
2	Name1	2/15/2013	100
3	Name1	5/15/2013	100
4	Name1	7/15/2013	50

and one containing the targeted budgets by Client for different periods of time:

Client	Budget	StartDate	EndDate
Name1	1000	2/1/2013	6/1/2013
Name2	2000	3/1/2013	8/1/2013

I need to create a chart having the dimension Client, Stard Date & EndDate and as expresion to calculate the SUM(Sales) restricted by the timeframe given by StartDate and EndDate of the trageted budget.

In above example, I need to get the sum for rows with ID 2 and 3 which has the Date between corresponding StardDate and EndDate from Client "Name1" (and so on for each client).

Do you know if there is a way to do that using Chart object?

Or I need to do this during loading script?

Thanks in advance

Laurentiu

Re: Filter values from one column based on values from other two columns

Gysbert_Wassenaar — Wed, 29 May 2013 12:15:55 GMT

See attached example.

Re: Filter values from one column based on values from other two columns

Wed, 29 May 2013 13:29:58 GMT

Tks,

That's it. The Join in the script is "the one"

topic Filter values from one column based on values from other two columns in QlikView

Filter values from one column based on values from other two columns

Re: Filter values from one column based on values from other two columns

Re: Filter values from one column based on values from other two columns