Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Customer & Partners, DEC. 9, 11 AM ET: Qlik Product & Strategy Roadmap Session: Data Analytics REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
njreardo
Contributor III
Contributor III

Select Example where example2 = 'Ex1' or 'Ex2' ...

I'm trying to load a table called "NAGM" and my code looks like the following-

NAGM:

Select [Manufacturer]

where Manufacturer = "Manu"

and Platform = "HUEY" or "JOHN" or "Eric" or "BENJAMIN" or "CAROL" or "LEE"

FROM [lib://AttachedFiles/Copy Pasted Current Report.xlsx]

(ooxml, embedded labels, table is Sheet1);

What am I doing wrong?

11 Replies
dan_sullivan
Creator II
Creator II

NAGM:

Load

[Manufacturer]

FROM [lib://AttachedFiles/Copy Pasted Current Report.xlsx]

(ooxml, embedded labels, table is Sheet1)

where Manufacturer = "Manu"

and Platform = "HUEY" or "JOHN" or "Eric" or "BENJAMIN" or "CAROL" or "LEE"

;

dan_sullivan
Creator II
Creator II

You may have to use the 'Match' for the where clause to complete the Or statement

dan_sullivan
Creator II
Creator II

something like this -

NAGM:

Load

[Manufacturer]

FROM [lib://AttachedFiles/Copy Pasted Current Report.xlsx]

(ooxml, embedded labels, table is Sheet1)

where Manufacturer = 'Manu'

and

Match(Platform ,'HUEY','JOHN','Eric','BENJAMIN','CAROL','LEE')

;

vinieme12
Champion II
Champion II

I suggest you go thru these posts first

New to QlikView Videos

njreardo
Contributor III
Contributor III
Author

How do I select only one manufacturer though? I want it to lock on one manufacturer and show the year after year change.

If you could tell me how to lock it too that would be great.

dan_sullivan
Creator II
Creator II

when you say lock on manufacturer what do you mean?  Are you trying to load the data table only for a single manufacturer?  Normally, you would load the entire dataset then you can use set analysis within your visualizations or measures to create one specific to a manufacturer.  Or you would just use the native functionality of Qlik to allow users to filter on any manufacturer they choose.

njreardo
Contributor III
Contributor III
Author

I'm trying to make it easier on the people who are going to be using this. That means that I have to replicate something that's already been done. I uploaded a picture to show what I mean. Unfortunately it's not pretty but it needs to be that way.

One manufacturer already chosen followed by a year over year view of what's going on with that manufacturer. Those fields are called CY 2013, CY 2014, CY 2015, etc.

dan_sullivan
Creator II
Creator II

no picture is available.

njreardo
Contributor III
Contributor III
Author

Example of GMNA.png