Discussion board where members can get started with Qlik Sense.
I am trying to do set analysis on one of dimension. I am trying to get in pivot table, company names for only year=2017
This is simple code, but I don't know why its not running. It's showing me invalid dimension. Please let me now what I am doing wrong or suggest any alternatives.
Go to Solution.
See if aggr() helps:
It is working. Can you please logic too. thank you so much
without aggr, you get multiple values of companies in 2017, so not only 1 value.
with aggr, you get 1 company in 2017 per company.