Fecthing '0' rows on using the complex query

[kumarkp412]

Hi All,

I need to use the complex query in Qlik sense.But when i tried to  the complex query, it was executed successfully and it was not showing any errors. But the problem is it was not fetching the rows as the query expected.

The complex query contains the 4 tables with having a joins and also a sub query had used on this.

How can i achieve the result of the query in the Qlik  sense.

Is it right way to use the complex query in Qlik sense.

Can any one guide me on this.

Thanks in advance.

Thanks

Kumar KVP

[sushil353]

Hi KVP,

Above information is not enough to give you any solution. Please share your query if possible.

HTH

Sushil

[luismadriz]

Hi, please share the load script,

I personally prefer to create the views with complex queries and load the result of the view to Qlik, but I guess it'll depend on your DBMS

Cheers,

Luis

[kumarkp412]

Hi Sushil,

Thanks for your reply,

The query contains the around 100 lines and below is the sample query i am trying to use. Please check it and let me know

Thanks in advance,

Thanks

Kumar KVP

[kumarkp412]

Hi Luis,

Thanks for your reply,

I agree your suggestion, but in that query i am having a dynamic filter as  date to take the current month data into qlik.

In this case how we can use the view with a filter.

Kindly guide me on this.

Thanks

Kumar KVP

[luismadriz]

I think you just need to prepare a view with x already filtered by ProductType and with the dates already converted to Date.

Then in qlik is just a where clause with the dates you need,

That's what I would do to minimise troubleshooting in Qlik

I hope this helps,

L

[kumarkp412]

Hi Luis,

I agreed, that we can have a where clause to filter the dates. But here the problem will occur  is , In my query their is sub query involved in it and it is also filtered with dates.

So in this case how we will filter the data.

if we remove the filter condition for the subquery then we will get the data as more 10 crs rows will come into the output. How we can achieve this.

Thanks in advance.

Thanks

Kumar KVP

[luismadriz]

Hi, if that's the case then it may not be possible to do it as a view if you'd like to control it from Qlik...

I have SQL Server and just tried sending a SQL statement with inner queries with inner parameters from Qlik and it worked for me.

Try taking smaller steps at a time, for example you could try running simpler queries to confirm the data connection, odbc or ole db connection

Also, make sure the data is not getting automatically concatenated to a similar previous table

I hope this helps,

Luis