New to Qlik Analytics

If you’re new to Qlik Cloud or Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!

Who Me Too'd this solution

kaanerisen
Creator III
Creator III

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;

 

 

View solution in original post

Who Me Too'd this solution