Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Coming your way, the Qlik Data Revolution Virtual Summit. October 27-29. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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
Highlighted
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"

;

Highlighted
Creator II
Creator II

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

Highlighted
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')

;

Highlighted
Champion II
Champion II

I suggest you go thru these posts first

New to QlikView Videos

Highlighted
Contributor III
Contributor III

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.

Highlighted
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.

Highlighted
Contributor III
Contributor III

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.

Highlighted
Creator II
Creator II

no picture is available.

Highlighted
Contributor III
Contributor III

Example of GMNA.png