Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
dilipkumard12
Contributor

Qlik Sense Only Function is not working

I have Tried the Only Function in Dimension.

It Showing the Invalid Dimension but expression is ok.

Please suggest any other alternative.

1 Solution

Accepted Solutions
Chanty4u
Esteemed Contributor III

Re: Qlik Sense Only Function is not working

have tried like this?

=aggr(only({<Dim={'Value'}>} ID),Dim1)

View solution in original post

4 Replies
Chanty4u
Esteemed Contributor III

Re: Qlik Sense Only Function is not working

can you shre your expression?

Chanty4u
Esteemed Contributor III

Re: Qlik Sense Only Function is not working

have tried like this?

=aggr(only({<Dim={'Value'}>} ID),Dim1)

View solution in original post

dilipkumard12
Contributor

Re: Qlik Sense Only Function is not working

Only({<Table_Name={'T1'}>} ID_Name)

Chanty4u
Esteemed Contributor III

Re: Qlik Sense Only Function is not working

in dimension 

expresion always with aggr will work.