Issue when loading binary and SQL datas

fgirardin — Wed, 25 Nov 2020 16:16:04 GMT

Hello,

I'm loading datas from a binary file "file.qvw" and load some other datas from the main SQL database

Note that the QVW is exported from the same SQL Database but I can't modify it

The QVW File loads several sales informations, like "ITEM N" "Sale Document N°" "Item Price"

This file loads only ITEMS linked to a Sale Document

Using this QVW, I can create the following table (simplified)

ITEM N DOCUMENT N° PRICE

M0840-0500-011A 011 0000 200

As I need more informations on specific items, I also load several fields from SQL directly

LOAD

ITEM N,

DETAILS;

From Database.dbo."ITEMLIST"

I can now modify my table as follow

ITEM N DOCUMENT N° DETAILS PRICE

M0840-0500-011A 011 0000 AAAB 200

The problem I'm facing is when I want to get informations about an ITEM that is not loaded by the QVW file but only by the SQL data

If I use a search field on my document, I see the ITEM N° that I'm looking for, but I cannot select it (greyed out)

This item has never been sold and has no documents attached to it. However, it still has several others informations that I'd like to display on the table, wich would look like this

ITEM N DOCUMENT N° DETAILS PRICE

M0840-0500-011A 011 0000 AAAB 200

M0840-0500-000A ABAB

Note that I use expression available in the QVW as well as SQL. To be sure, I didn't load the binary field and I can select all the previously greyed ITEMS

As I understand (or not), data not loaded by the QVW file are not loaded from any other source ?

Is there a way to "force" load datas from SQL even if not present in the QVW ?

I tried exporting all QVW tables as QVD, Drop tables then import QVD, but it doesn't work (or at least, i was not able to make it work)

Thank you for any help you can provide.

Cheers

Fabien

topic Issue when loading binary and SQL datas in QlikView

Issue when loading binary and SQL datas