Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

Set analysis on dimension

Hi,

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

For Example:

ONLY({<YEAR={'2017'}>}company)

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.

Thanks

1 Solution

Accepted Solutions
mov
Esteemed Contributor III

Re: Set analysis on dimension

See if aggr() helps:

aggr(ONLY({<YEAR={'2017'}>}company),company)

3 Replies
mov
Esteemed Contributor III

Re: Set analysis on dimension

See if aggr() helps:

aggr(ONLY({<YEAR={'2017'}>}company),company)

Not applicable

Re: Set analysis on dimension

It is working. Can you please logic  too. thank you so much

mikaelsc
Contributor III

Re: Set analysis on dimension

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.