topic SQL select - unique values / rows in QlikView

SQL select - unique values / rows

Tue, 14 Oct 2014 13:16:03 GMT

Hi everybody.

I have a script for loading data from a MS SQL database.

---------------------------------------------------------------------------

SQL SELECT serie as Séria, Stav, DATUMOBDOBI as Obdobie, 'A01PM' as Kód, -1*N3 as Čiastka, nazevst as Projekt,

nazevod as Odberateľ, Rok, FAZE as Fáza_RSV, FAZESTAV as Fáza_Stav_RSV, 'B01REAL' as Fáza, CISLOSTAVBY,

Úspešnosť, ZDROJ_KOMBINOVANE_SERIE, KLAS_PROD, CHAR_STAVBY, SEGMENTY, PODSEGMENT, nazevob

FROM "rsv2_stav".dbo."qryDatovySklad_QlikView";

---------------------------------------------------------------------------

It looks like working OK, but data are not completely correct.

After hours of looking for a mistake I noticed, that SQL select works like in unique values / rows mode.

Am I right ?

I need to import into QV ALL rows no matter if they have unique values or unique rows.

How can I do it ?

Thank you in advance.

Duski

Re: SQL select - unique values / rows

Gysbert_Wassenaar — Tue, 14 Oct 2014 13:59:14 GMT

Open the table viewer and hover the mouse over the table you loaded so that the number of records in the table is shown. Check that number with the number of records in your source table in your SQL Server database. In Qlikview in sheet objects like a table box duplicate records are not shown. But that does not mean that not all the data was loaded.

Re: SQL select - unique values / rows

Tue, 14 Oct 2014 14:56:27 GMT

Thank you for you answer, Gysbert.

Update !!!

I proceeded the controlment from the other side.

I filtered data in QV to the lovest level until I could localize the difference between source data and data in QV.

And now the problem looks completely different !

Imported data are OK, but the sum expression in the plain table works like in unique values mode !!!

Sum of 9 values in the rightmost column is not -10 144,08 (which shows the table), but 10146,37, which is correct !!!

That's why I changed the total mode to Sum of rows - and now data look OK.

Thank you.

Duski.