Which Query?

[#1]

Hello,

I have three queries.

In these queries, you have same columns, but where clause is different.

I want that an expression selects the value from a specific query.

How do i do this?

[Anonymous]

Hi,

Please post queries,So can help.

Regards

Neetha

[#3]

SELECT

Year

,Country

sales

FROM B

WHERE SalesDate = trunc(SYSDATE);

select Year

,Country

,Sales

From C

[Anonymous]

Hi ,

Can you elaborate on your requirement?

[#5]

Yes,

I want to select the total sales for today.

Because i want this every 5 minutes, i have two queries.

The First ..... where SalesDate = trunc(SYSDATE)  i load partial

the other once a day.

So i want to refer in  a chart to the first query .... How can i involve this, that chart looks in first query.

[MarcoWedel]

SELECT

Year

,Country

sales,

'B' as Source

FROM B

WHERE conditionB;

SELECT

Year

,Country

sales,

'C' as Source

FROM C

WHERE conditionC;

Use the source field in your expressions to calculate only with records loaded from a specific source.

Hope this helps

Regards

Marco

[#7]

=Sum( ....,SOURCE={"A"} >} SALES )

IS THIS CORRECT ADDED? THE SOURCE?

[Anonymous]

Hi,

Further to marco's solution:

SELECT

Year

,Country

sales,

'B' as Source

FROM B

WHERE conditionB;

SELECT

Year

,Country

sales,

'C' as Source

FROM C

WHERE conditionC;

use below syntax in chart expresion:

=Sum({<source = {'B'}>},sales)

Regards

Neetha

[#9]

when i use that, nothing more works

[#10]

Better is using UNIQUE Column Names