2 queries

[#1]

i have 2 queries.

1. query select cars from allcars

2. query select cars, mobiles from allmobiles where mobiles = 'T1'

I have two table objects.

query 2 shows me no rows, but in qlikview it shows me the cars from allcars query and mobiles is null.

i don't want to show query 2 any row because output is zero rows.

why does qlikview this and how can i fix this.

[robert_mika]

Could you post your query here?

[pamaxeed]

Is there a relation between query 1 and query 2?

It seems u created the car as key field and when you are trying to display the results in a table it shows you the result of query 1 because you have defined most probably the field car as key field in your data modell.

If you could post the sample, it would much easier to help u.

Cheers,

Patric

[#4]

the example is complicated and you have to need the data as well. i can't send you the source because it is private.

the example is enought. the cars field is key, because it is used in both queries. that's correct.

but in the table of query 2 it shows me also the results of query 1 with mobiles null.

this is becaus no cars are present in query 2

[pamaxeed]

You mean in the GUI when you are talking about tables?

If yes which table are you using: Straight Table, Pivot Table, Tablebox ?

Which dimension you have in your table and which expression if you are using Straight table or pviot table?

[pamaxeed]

[#7]

straight table

[pamaxeed]

I still not understood what you wanna achieve....but...

you can create a calculated dimension like:

if(Isnull(mobile), null(), cars)

and check the supress null values, you will see that in table 2 you will have displayed cars only if mobile is different then null()....

[#9]

i think you understand me

table 1 i want to see all the cars

table 2 i want to all the cars selected in table 1 if there is also a mobile there

if not i don't want to see any result in table 2

thx for helping me!

[pamaxeed]

which dimensions you have in table 2 ?

Just do like i suggested you:

Create a calculated dimension like that:  if(Isnull(mobile), null(), cars).

Cheers,

Patric