Query Positioning

pandreozzi — Fri, 13 Oct 2017 17:54:38 GMT

I have a sql query that works fine when I run this in my SQLYog app.

SELECT * FROM SW_PROD_RELEASE WHERE SWSUBTYPE IN ("Router","Data Switch","Firewall","Voice Switch");

I would like to use this in my Qlikview app to pull out what is in the ()

Below is my Load and SQL statements in Qlikview.

Note: below is only part of the load and sql statements. If more is needed I may be able to provide it but I think this is enough.

I would prefer to run all my queries in the code here rather than using dimensions or expressions

QLIKVIEW Code Below

Flatfile:

LOAD

ASSET_CLASS

SQL

SELECT

PN.SWSUBTYPE ASSET_CLASS, (NOTE this is where the mapping happens for the sub-type to asset_class in the load statement)

FROM GPS.SW_PROD_RELEASE PN

My goal is to limit what is being pulled out of the SW_PRODUCT_RELEASE table to what is in () in the SQLYog query.

Thanks in advance.

topic Query Positioning in QlikView