Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
pandreozzi
Creator
Creator

Query Positioning

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.

0 Replies