Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Save the Date: QlikWorld Online, June 24-25, 2020. Free global virtual event for data integration and data analytic gurus. Register Today
Highlighted
New 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?

Tags (2)
11 Replies
Highlighted
Contributor II

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

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
Contributor II

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

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

Highlighted
Contributor II

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

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
Esteemed Contributor II

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

I suggest you go thru these posts first

New to QlikView Videos

Highlighted
New Contributor III

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

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
Contributor II

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

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
New Contributor III

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

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
Contributor II

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

no picture is available.

Highlighted
New Contributor III

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

Example of GMNA.png