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

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
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