Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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;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.
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?
One more example
load
AGMODL as [Model code],
AGDEVC as [Developing code],
AGSERI as [Serie],
AGMODS as [Model description]
;
sql
select
* from bmwdta.warmodwhere (AGSERI >= '03' and AGSERI <= '05') OR agseri = 'G5';
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;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;
Thanks Ansch,
That only seems to load in deal number 900000 though, it ignores the range 200020 - 200050
Hi
Strange.
It works for me, the 2 example I post is running everyday and works fine.
Anders
Ignore me, it works great! 🙂
I made a mistake while copying and pasting..
Thanks very much for all your help 🙂