Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Announcements
Announcement: Certain actions are currently causing a Page Not Found error. This is a known issue and we are working with the platform vendor to investigate and resolve it.
dan-ketil
Contributor II

Direct Discovery usage

Hi

I have an app that uses the foloowing code:

ActualTag:

LOAD

    SegmentResponseGlobId,

    DateTime,

    Tagname,

    Value,

    UOM;

SQL SELECT *

FROM MESLogDB.dbo.ActualHistorian;

It returns a number of tags pr datetime with value for me to build trends on.

The SegmentResponseGlobId is the key.

The table is huge so what I now want is to get only the data for a spesific SegmentResponseGlobId.

I have another report where we list all SegmentResponseGlobId and current data. I want the user to choose a spesific SegmentResponseGlobId and then jump to this new report, ActualTagHisotry.

This should then fire the sql based in the input field and return the following four fields.

   DateTime,

    Tagname,

    Value,

    UOM;

Another option is to buid the SegmentResponseGlobId list in my ActualTagHisotry report and they choose from there, and then the sql code fires. I prefer the first, but I am fine with the latter as well.

Comments on apporach?

BR

Dan

4 Replies
dan-ketil
Contributor II

Re: Direct Discovery usage

I tried to build with the following

CurrentTag:

DIRECT SELECT

    SegmentResponseGlobId

    ,DateTime

    ,Tagname

    ,Value

    ,UOM

FROM  $(StringSQL);

ActualTag:

LOAD

    SegmentResponseGlobId

/*    ,DateTime

    ,Tagname

    ,Value

    ,UOM */

    ;

SQL $(StringSQL);

Not really sure if I would need the AactualTag Section. I have another tab where I get all the batch info and also the SegmentResponseGlobId that is used in my direct statement

A user select a batch and press the store button, this stores the following sql query code:

SELECT * FROM MESLogDB.dbo.ActualHistorian where SegmentResponseGlobId ='E35907E8-E422-4801-805C-5394D07E3330'

Ideally I do not want the button. It should be that the user select a batch and upon clikcing a batch the direct sql  code should start

When trying to tun, the code stops giving the following error:

Unknown statement

CurrentTag:

DIRECT SELECT

    SegmentResponseGlobId

    ,DateTime

    ,Tagname

    ,Value

    ,UOM

FROM  SELECT * FROM MESLogDB.dbo.ActualHistorian where SegmentResponseGlobId ='E35907E8-E422-4801-805C-5394D07E3330'

Hope that somebody can provide som input on what I am doing wrong.

BR

Dan

Not applicable

Re: Direct Discovery usage

check the version of the qlikview been used, Direct discovery is only in 11.2

Highlighted
dan-ketil
Contributor II

Re: Direct Discovery usage

Version: 11.00.11282.0.SR1 64-bit Edition (X64)

Guess that means that I will need an upgrade.

BR

Dan

Not applicable

Re: Direct Discovery usage

Yeah,

so qvw is nt reading DIRECT word, get an upgrade

also do me a favour, whn doing the upgrade can u note down the steps to be followed for upgrading and send me

i also hav to do this activity at my client place...