Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

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 III
Champion III

I suggest you go thru these posts first

New to QlikView Videos

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.
Anonymous
Not applicable
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.

Anonymous
Not applicable
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.

Anonymous
Not applicable
Author

Example of GMNA.png