topic Re: Which Query? in QlikView

Which Query?

Mon, 26 Jan 2026 18:19:17 GMT

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?

Re: Which Query?

Anonymous — Sat, 20 Dec 2014 20:17:51 GMT

Hi,

Please post queries,So can help.

Regards

Neetha

Re: Which Query?

Sat, 20 Dec 2014 20:28:25 GMT

SELECT

Year

,Country

sales

FROM B

WHERE SalesDate = trunc(SYSDATE);

select Year

,Country

,Sales

From C

Re: Which Query?

Anonymous — Sat, 20 Dec 2014 20:34:10 GMT

Hi ,

Can you elaborate on your requirement?

Re: Which Query?

Sat, 20 Dec 2014 20:43:42 GMT

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.

Re: Which Query?

MarcoWedel — Sat, 20 Dec 2014 20:46:59 GMT

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

Re: Which Query?

Sat, 20 Dec 2014 21:02:11 GMT

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

IS THIS CORRECT ADDED? THE SOURCE?

Re: Which Query?

Anonymous — Sat, 20 Dec 2014 21:04:10 GMT

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

Re: Which Query?

Sat, 20 Dec 2014 21:16:41 GMT

when i use that, nothing more works

Re: Which Query?

Sat, 20 Dec 2014 21:39:01 GMT

Better is using UNIQUE Column Names

Re: Which Query?

Anonymous — Sun, 21 Dec 2014 09:26:04 GMT

Hi,

What is the issue