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

martinpohl
Partner - Master
Partner - Master

so, use an aggregated dimension for field FA:

aggr(if([Gesamt letzter AT]>0,FA),FA)

while FA is the dimension of field FA and [Gesamt letzter AT] is the master expression of the last column.

Then deactivate "show null values" on first dimension.

Regards

View solution in original post

Who Me Too'd this solution