direct discovery issue

[alec1982]

Hi all,

I am trying to use direct discovery to load data from SQL but it is not working for me.

Currently, the script is as follow

TableA:

SQL Select

User,

City,

Country,

Sales,

Margin from table xyz;

working fine but when I add DIRECT SELECT I get error..

TableA:

DIRECT SELECT

User,

City,

Country,

Sales,

Margin from table xyz;

Any idea?

Best,

Alec

[petter]

Due to the interactive and SQL-specific nature of Direct Discovery, only certain QlikView objects can use MEASURE fields. List boxes, Multi boxes, Statistics boxes, and mini charts are not supported with MEASURE fields.

[antoniotiman]

Where You cannot Find Measures ?

View Tables don't display Measures.

[petter]

I am not sure that I understand your question... do you wonder whether Table View shows Measures?

[antoniotiman]

Table View don't show Measures, only Dimensions.

[antoniotiman]

Now You can use dimensions and mesures in chart like

Pivot Table

Dimension ID

Expression Sum(BenchMarkValue)

[petter]

Yes that is correct - here is a quote from the help file:

MEASURE fields, on the other hand, are recognized on a "meta level." MEASURE fields are not loaded in memory (they do not appear in the Table View).

[alec1982]

thank you both for walking me through this.. really appreciate it!

I understand it now. I see the measure when trying to create a chart. but when I do benchmark as dimension on the chart and sum(BenchMarkValue) as expression I get an error where the chart says database connection failed..

any idea?

[antoniotiman]

Any Dimension or only BenchMark (not benchmark).

Try to create list box with dimension (e.g. ID).

[alec1982]

I am fine with the dimensions.. and also the measure shows up when trying to create a chart. I didn't type them in I selected them from the lists..

the issue now is that the charts show " database connection failed".

[petter]

Is the database down for system maintenance?