Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
i have the following expression but want to change is slightly so it incorporates some kind of between funciton
=IF(Latitude > Lat1 AND Latitude < Lat2 AND Longitude > Long1 AND Longitude < Long2, Area,'')
thanks all
There is no between function or operator in Qlikview. In some cases, you can use interval matching to set a flag in the load script, but I don't know how to do that with two matches.
thought that was the case, not a huge issue i can write a lengthy if statement to capture all the iterations, not really that many.
Dear Samuel,
Please try listed below script,
--
Load Area
From YourDataSource
Where Latitude > Lat1
And Latitude < Lat2
And Longitude > Long1
And Longitude < Long2;
Please note, Here in QlikView we use IntervalMatch function instead of Between function.
Kind regards,
Ishfaque Ahmed
Create the Flag in Script
IF((Latitude > Lat1 AND Latitude < Lat2) AND (Longitude > Long1 AND Longitude < Long2), 1,0) as Flag_Lat_Long
Now you can use this Flag in Where Clause or in Chart using set analysis
Is there any link between Table 1 & table 2?
try this:
=IF((Latitude > Lat1 AND Latitude < Lat2) AND (Longitude > Long1 AND Longitude < Long2), Area,'')
make sure all are in number
Thanks for the help Kush,
no there isnt a link between the two tables and im trying everything i can think of to get this to work.
i cant get my head around the problem. I know you guiys are far more intelligent than i am so obviously im not explaingin very well.
here we go
[MIDAS]
LOAD [Geographic Address],
Latitude,
Longitude
FROM
(qvd);
[AQMA]
LOAD Area,
Lat1,
Lat2,
Long1,
Long2
FROM
(ooxml, embedded labels, table is Sheet1);
i want the AQMA table to join onto the MIDAS table, as you can see no link, what i want is the =IF(Latitude > Lat1 AND Latitude < Lat2 AND Longitude > Long1 AND Longitude < Long2, Area,'') function to be the criteria for what value is put where.
your help is very much appreciated.
What about the solution I've suggested to your discussion here: