Qliksense- Query is running fine in Database and the same is not running in Qliksense

[viveksingh]

Hi Experts,

I have one SQL query which is running fine in Database and the same query is not running in QlikSense.

Can any one please let me know what could be the reason for it?

Please note that the same query is able to run in QlikView.

and the connections strings in both QlikView and QlikSense were fine.

Thanks,

Vivek

[viveksingh]

Below is the error

[guruprem]

Can you debug? It might show you clear error message

[devarasu07]

Hi,

Can you share your sql query which your trying in qlik sense.can you share issue with mock data. tks

[viveksingh]

Attached is the Query which I'm using.