Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Can a dimension reference an expression value

I am trying to add a calculated dimension such that if the evaluated expression for my "Expressions" column is a certain value, I want the dimension to display null so that I can supress it and the row will not display. There doesn't seem to be a way to do this and for Expression columns, you can not suppress a row if it is null, you can only hide the column entirely.

example:    = if ( [Bucket] != 'NA', FIRM_NAME, null())

Thanks in advance.

1 Reply
MK_QSL
MVP
MVP

= if ( [Bucket] <> 'NA', FIRM_NAME, null())


OR


If(Aggr(sum(Bucket),FIRM_NAME)<>0,FIRM_NAME)