topic Key/Join Problem in QlikView

Key/Join Problem

Fri, 22 Jul 2011 15:35:19 GMT

Hi,

I have a table which is joined to another table on the basis of 2 fields. The problem is that one of the tables has only 3 days worth of data and the other table has data from May onwards. However, i am only able to see data from 3 days due to the join.

I have attached my app with this discussion and also shown the graphs and tables you might need to see.

How can i see all the data?

Thanks.

Key/Join Problem

Mon, 25 Jul 2011 13:50:41 GMT

hi,

i cant able to open ur application its getting fell to open.

u can get all data after appliying join on key field' Date' of two table.

Key/Join Problem

Mon, 25 Jul 2011 14:22:01 GMT

Hello,

for my oppinion both charts are correct. For ex. in the left chart the dimensions are DATE and user_type. In the underlying tables are three dates and all valid data belonging to these are shown (summed up). Valid data in this case is a value in all three fields: DATE and user_type and current_cost (via queriesperday.K1 and K2). To verify (test) this build a tablebox (not a chart) containing this three fields. There you can find all nullvalues as dashes.

If you want to see "all" data in a chart, even null-values, there are some options to be (un-)checked:

tab Dimensions --> "Supress When Value Is Null" (for every dim !)

tab Dimensions --> "Show All Values" (for every dim !)

tab expressions --> "Suppress Zero-Vals"

tab expressions --> "Suppress Missing"

But I guess You won't be happy when you see "all data".

Regards, Roland

Key/Join Problem

Wed, 27 Jul 2011 21:56:06 GMT

Howzit,

I think its just that your links are scattered,'Fresh fix-ups'almost always come from an organised prob,

Pull in the tables the same way you did,just Make sure the MAIN Table has a consistant ammount of fields able -

-to link all needed tables,ofcourse Watching for synthc keys but all else looks right,

I would(if stuck in your position) also find all null values 1st,from there...no idea as iv also just recently started.

hope you get it right.

jay