Qlik Community

QlikView Deployment

Discussion Board for collaboration related to QlikView Deployment.

Not applicable

Which Query?

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?

10 Replies
neetha_p
Honored Contributor

Re: Which Query?

Hi,

Please post queries,So can help.

Regards

Neetha

Not applicable

Re: Which Query?

SELECT

Year

,Country

sales

FROM B

WHERE SalesDate = trunc(SYSDATE);

select Year

,Country

,Sales

From C

neetha_p
Honored Contributor

Re: Which Query?

Hi ,

Can you elaborate on your requirement?

Not applicable

Re: Which Query?

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?

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

Not applicable

Re: Which Query?

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

IS THIS CORRECT ADDED? THE SOURCE?

neetha_p
Honored Contributor

Re: Which Query?

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

Not applicable

Re: Which Query?

when i use that, nothing more works

Not applicable

Re: Which Query?

Better is using UNIQUE Column Names

Community Browser