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

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

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

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?

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

dan_sullivan — Thu, 10 Aug 2017 14:26:50 GMT

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"

;

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

dan_sullivan — Thu, 10 Aug 2017 14:28:06 GMT

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

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

dan_sullivan — Thu, 10 Aug 2017 14:33:41 GMT

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

;

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

vinieme12 — Thu, 10 Aug 2017 14:41:31 GMT

I suggest you go thru these posts first

New to QlikView Videos

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

Anonymous — Fri, 11 Aug 2017 14:21:52 GMT

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.

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

dan_sullivan — Fri, 11 Aug 2017 15:36:14 GMT

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.

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

Anonymous — Fri, 11 Aug 2017 15:45:29 GMT

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.

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

dan_sullivan — Fri, 11 Aug 2017 15:53:19 GMT

no picture is available.

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

Anonymous — Fri, 11 Aug 2017 18:04:03 GMT

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

veidlburkhard — Sat, 12 Aug 2017 09:56:02 GMT

Hi Nicholas,

the conditions in your where clause should be (Platform = 'HUEY' or Platform = 'JOHN' or...) see below:

NAGM:

Load

[Manufacturer]

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

(ooxml, embedded labels, table is Sheet1)

where Manufacturer = 'Manu'

and (Platform = 'HUEY' or Platform = 'JOHN' or Platform = 'Eric' or Platform = 'BENJAMIN' or Platform = 'CAROL' or Platform = 'LEE')

Hope this helps

Burkhard

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

sasiparupudi1 — Sat, 12 Aug 2017 12:15:01 GMT

Where are the year and amount fields being selected in your script?

Please upload a sample excel file with your data so that the guys in the community can better guide you.

Sasi