Discussion board where members can get started with Qlik Sense.
I am stuck in a problem.
I have two tables. lets say T1 and T2 like this
Result I need:
I want to get all the values from "SubId" which are not 0 in the new table.
Go to Solution.
Just a small correction
select Subid as mainID
from table1 where Sunid<>0
select mainID from table2
select Subid from table1 where Sunid<>0
Thanks for the solution