Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

njreardo
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?

Tags (2)
11 Replies
dan_sullivan
Not applicable

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"

;

dan_sullivan
Not applicable

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

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

dan_sullivan
Not applicable

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
vinieme12
Not applicable

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

I suggest you go thru these posts first

New to QlikView Videos

njreardo
Not applicable

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.

dan_sullivan
Not applicable

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.

njreardo
Not applicable

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.

dan_sullivan
Not applicable

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

no picture is available.

njreardo
Not applicable

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

Example of GMNA.png