topic Re: 2 queries in QlikView

2 queries

Wed, 07 Oct 2015 11:59:06 GMT

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.

Re: 2 queries

robert_mika — Wed, 07 Oct 2015 12:19:05 GMT

Could you post your query here?

Re: 2 queries

pamaxeed — Wed, 07 Oct 2015 12:25:59 GMT

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

Re: 2 queries

Wed, 07 Oct 2015 12:30:39 GMT

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

Re: 2 queries

pamaxeed — Wed, 07 Oct 2015 12:35:51 GMT

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?

Re: 2 queries

pamaxeed — Wed, 07 Oct 2015 12:36:41 GMT

Re: 2 queries

Wed, 07 Oct 2015 12:51:12 GMT

straight table

Re: 2 queries

pamaxeed — Wed, 07 Oct 2015 12:55:08 GMT

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()....

Re: 2 queries

Wed, 07 Oct 2015 13:31:37 GMT

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!

Re: 2 queries

pamaxeed — Wed, 07 Oct 2015 13:35:39 GMT

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

Re: 2 queries

Wed, 07 Oct 2015 14:04:34 GMT

table box