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

Loop

Hi,

I am new to qlikview not sure how can I perform following functionalities in qlikview (Kindly see the attached image for more information on data)

Fix offset:

Load

     ID number

     Description

     Amount1

     Amount2

     Total

(Under one ID I have multiple lines of descriptions and related amount1 or amount2)

Based on ID number check if any values of amount1 is equal to any values in amount2. If cell value matches then changes values of corresponding rows in total to zero. Like C and -C in attached file to zero. Its not necessary that they can be next to each other.

Loop this on n number of ID number .

Based on ID I am trying to match values in same colored cells. For example 2000 and -2000. In this fashion I have to check n number of ID.

10 Replies
Not applicable
Author

Yes I can see it