topic help with my script in QlikView

help with my script

hopkinsc — Thu, 22 Jul 2010 10:03:11 GMT

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?

help with my script

Thu, 22 Jul 2010 10:13:42 GMT

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;

help with my script

Thu, 22 Jul 2010 10:16:34 GMT

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.

help with my script

Thu, 22 Jul 2010 10:19:06 GMT

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?

help with my script

Thu, 22 Jul 2010 10:31:52 GMT

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

help with my script

hopkinsc — Thu, 22 Jul 2010 10:37:16 GMT

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;

help with my script

Thu, 22 Jul 2010 10:49:18 GMT

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;

help with my script

hopkinsc — Thu, 22 Jul 2010 10:58:07 GMT

Thanks Ansch,

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

help with my script

Thu, 22 Jul 2010 11:04:34 GMT

Strange.

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

Anders

help with my script

hopkinsc — Thu, 22 Jul 2010 11:21:33 GMT

Ignore me, it works great! 🙂

I made a mistake while copying and pasting..

Thanks very much for all your help 🙂