how to pass multiple values from island table and get the output results using set analysis?
I have two tables, one is island table 1, it only stores calendar data, and the other one is table 2, like the following:
Table 2 :
I need to pass multiple selected values from table 1.[Col A], and do the comparison with Table 2.[Col C] , Table 2. [Col D], and Table 2. [Col E], and then count how many Table 2.[Col B] meets the criteria, for example: if Table 1. [Col A]>Tabel2.[Col C] or Table 1. [Col A]=Table2.[Col D] or Table 1.[Col A]<Table 2.[Col E], then count Table 2.[Col B] ,and based on the total counts on Table 2.[Col B], if the number of count is great than 2, then the output would be the values of Table 1.[Col A].
I am new in Qlikview , and not sure if it can be done in Set Analysis.
There are ten and thousand rows of data on Table 2, I need to find out the total number of Table1. [Col A], which is based on the total count of table 2.[Col B] with great than 2, and the comparison between Col (from Table 1) with Col C, Col D and Col E (from table 2)
=Sum(Aggr(If(Col > [Col C] or Col = [Col D] or Col < [Col E], Count([Col B])), Col, [Col C], [Col D], [Col E], [Col B]))
Just as a suggestion, please mark the answer that was actually correct and not randomly mark any response as correct. The idea is that these posts can be seen by other users who would want to look at what was the correct response. In this case if somebody will come to this screen, he will see this as the correct response:
Is that helpful for other users? Not at all. Please make this community a better place for yourself and others