Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
IMPORTANT security patches for GeoAnalytics Server available to download: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Time Match Interval Duplication

I am trying to get Zone and Percentage for a specific Device and time. That is I am matching Interval Device and Time with Time Interval to get its Zone and Percentage. The Device can be connected to multiple devices with percentage allocated. But it is working fine with single row but as soon as there are x-squared lines to one interval there is x duplication of lines in end result. For example I have made 3 Zones for a specific interval so there are 9 lines instead of 3 lines.

Can anyone help to eliminate the extra rows or alternate solution

1 Solution

Accepted Solutions
Not applicable
Author

Aamir,

Please find attached file hope this will help

View solution in original post

7 Replies
Not applicable
Author

Hi Aamir,

I'm facing the same problem if anyone have idea please share.

Not applicable
Author

Adeel

swuehl

Gysbert Wassenaar

Guys please reply

whiteline
Master II
Master II

Load distinct

Not applicable
Author

where should i use distinct. I mean in which load as I can't use it interval match

whiteline
Master II
Master II

You have to prepare the table before using interval match.

Create temporary table with load distinct.

Not applicable
Author

Can you do this in my QVW because i don't think that's right solution as multiple lines are required in temp table of Interval match

Not applicable
Author

Aamir,

Please find attached file hope this will help