Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
If you’re new to Qlik Cloud or Qlik Sense, start with this Discussion Board and get up-to-speed quickly.
Alternatively, you can use a reference table.
Ref_Table:
Load ID,max(MKY) as MKY from Source Group By ID;
Fact_Table:
Load * from Source where Exists(MKY);
Drop Table Ref_Table;