help with my script

[hopkinsc]

Hi, In my Deal Analysis application, i currentl load in 200+ DealNumbers. the numbers range from 1 - 1000000.

I have written an appliaction which will only report on LUNCH TIME MEAL DEALS. There are 51 deal numbers which are included, which are :

200020 - 200050

900000

how can i only load in these specific DEALNUMBERS, rather than everything?

I know how to load in ONE number, but am unsure on how to load in a range (200020 - 200050) and a specific one (900000)

Any ideas?

[#2]

Hi

Here is a example

Load

PlanKey%,

sum([P09_Total value in object currency]) as [P09_Total value in object currency]

FROM

c:\qlikview\Data_files\Plans09_1.qvd (qvd)

where

([P09_Cost elementText]>='0000400000' and [P09_Cost elementText]<='0000499000') or

([P09_Cost elementText]>='0000600000' and [P09_Cost elementText]<='0000799000') or

([P09_Cost elementText]>='0000855000' and [P09_Cost elementText]<='0000855099') or

[P09_Cost elementText] ='0000810081'

group

by PlanKey%, Intord;

[#3]

Hi,

Do you want to load these numbers while creating table/pivot chart or in script?

Also, what are other parameters in this application?

Share some sample data/QV file.

[#4]

can yuo do this in your SQL?

something like

WHERE DealNumber between 200020 and 200050 (assuming they are numerical)

and use an OR for the other one?

[#5]

One more example

load

AGMODL as [Model code],

AGDEVC as [Developing code],

AGSERI as [Serie],

AGMODS as [Model description]

;

sql

select

* from bmwdta.warmod

where (AGSERI >= '03' and AGSERI <= '05') OR agseri = 'G5';

[hopkinsc]

I need it in my script.

At the moment, i have this in my script which only loads in dealnumber 900000

FROM

This works great, but now i want to expand it to include the range 200020 - 200050

;

$(cFileName) (qvd) WHERE DealNumber = 900000;

[#7]

Try this

This works great, but now i want to expand it to include the range 200020 - 200050

;

$(cFileName) (qvd) WHERE (DealNumber >= 200020 and DealNumber <= 200050) or DealNumber = 900000;

[hopkinsc]

Thanks Ansch,

That only seems to load in deal number 900000 though, it ignores the range 200020 - 200050

[#9]

Hi

Strange.

It works for me, the 2 example I post is running everyday and works fine.

Anders

[hopkinsc]

Ignore me, it works great! 🙂

I made a mistake while copying and pasting..

Thanks very much for all your help 🙂