Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

dilipkumard12
New Contributor II

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
sureshqv
Esteemed Contributor III

Re: Qlik Sense Only Function is not working

have tried like this?

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

4 Replies
sureshqv
Esteemed Contributor III

Re: Qlik Sense Only Function is not working

can you shre your expression?

sureshqv
Esteemed Contributor III

Re: Qlik Sense Only Function is not working

have tried like this?

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

dilipkumard12
New Contributor II

Re: Qlik Sense Only Function is not working

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

sureshqv
Esteemed Contributor III

Re: Qlik Sense Only Function is not working

in dimension 

expresion always with aggr will work.

Community Browser