topic Consolidating dates from different tables in QlikView

Consolidating dates from different tables

Wed, 11 Jan 2017 13:03:54 GMT

Hi all,

I have a Qlikview report with two different dates to be consolidated. I have used data island technique throughout my report for other dates. So I am using same for these two dates also.

In my sample app I have loaded those two dates and concatenated into one to use it in my dashboard. The actual concatenation fetches many rows while loading via script. Also , logically it displays incorrect count in the dashboard table. Please help in resolving this issue to display correct results in the dashboard.

WR,

James !

Re: Consolidating dates from different tables

annafuksa1 — Wed, 11 Jan 2017 13:53:42 GMT

First think you have synthetic key and those cause some problems.

you can create 2 calendars (sorry do not have qvd so cannot make any changes in app)

or load the same data twice one with date1 as Date_field and second with date2 ad Date_field and ad flag one for 1 date1 and 2 for date2 and toggle depends what date the calculation should be made base of.

Re: Consolidating dates from different tables

Thu, 12 Jan 2017 07:04:27 GMT

Thanks for your reply.

I cannot avoid that syn key as i need both of the data in my report. Secondly , if you open my report and see the script, the date fields I have loaded in the table 'OrderLinesDate' loads 30 million rows which seems wrong. I want to load this in correct way. Those date fields come from two different tables (see the script above this table's script). I don't know whether I have loaded it in correct way by using multiple 'IF' in the load script. Please help.

Re: Consolidating dates from different tables

annafuksa1 — Thu, 12 Jan 2017 10:17:02 GMT

ok, so do not use this 2 fields and instead use

'KNES' & [Supplier Code] as %KeyKNES,

this way you will use both fields and avoid synthetic key.

probably there is somewhere wrong left join (ex. relation 1 to many) and it blow your table .

with our QVD I cannot say where is e problem.

try to reload the tables one join on a time like

only 1st table, - check number of rows

only 1st and 2nd table - check number of rows

only 1st 2nd and 3th table - check number of rows

....

to see where is a problem