Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Problem - Need an advise here....

Hello

We have 2 tables:

1) Table 1 contains the column "Distance" and column "MeterID"  , There are 1700 MeterID and the distance is in intervals 0-0.5Miles, 0.5-1Miles, etc...

2) Table 2 contains the column "UnitID" which is same as "MeterID" (only different name) and column which name is "RSSI".

I created graph that lists the no. of MeterID's (y axis) in each distance interval , i.e 0-0.5 Mile - 30 Meters, 1-1.5 Miles 20 Meters etc

(this is based only on table 1)

need:

To Create another column name "RSSI" (from the second table) according to the distances intervals (from the first table)

Thanks

Oded

7 Replies
Not applicable
Author

forgot to mentioned that RSSI is a number

Michiel_QV_Fan
Specialist
Specialist

You need an interval match. This needs to match the UnitID value in the distance interval.

saumyashah90
Specialist
Specialist

Rename  UnitId as MeterID in the script

Anonymous
Not applicable
Author

Load UnitID as MeterID and Qlik Sense will automatically connect the two tables on MeterID

Not applicable
Author

thanks

Not applicable
Author

thanks

Not applicable
Author

thanks