Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

Error when using Direct Discovery saying "Direct query returned empty result set"

 

Hi All,

 

I am trying to pass a dynamic value$(vMonth) to the FROM clause of the DIRECT QUERY in the script. It works fine for the initially loaded month's data. But it’s throwing an error when I select a different month, which is passed through the variable $(vMonth) to the FROM clause to fetch the corresponding Months data. Here is the code where I am using the $(vMonth) in the FROM clause.

 

Table:
DIRECT QUERY
DIMENSION
.

  .

MEASURE
………

FROM schema.$(vMonth);

 

This is working only if I reload the app after a different month is selected. Is there a way to fetch the data corresponding to the value of $(vMonth) without reloading from the DIRECT QUERY ?

 

Below is the error I get…..

Thanks in advance..... 

Community Browser