Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Not applicable

Show Diemsion based on Column Results

Hi All,

Does anyone know how to only show the dimesion rows where a columns results are greater than zero, thanks.

Here is some code im using in the "Add Calculated Dimension" box of the Dimensions tab.

 

=IF([ColumnName] > 0, ETMSpecialty)

Thanks

Martin

1 Solution

Accepted Solutions
whiteline
Honored Contributor II

Re: Show Diemsion based on Column Results

Try to use column Expression insted of [ColumnName].

Also rewrite your expression like this:

=aggr(IF((ColumnExpression) > 0, ETMSpecialty), ETMSpecialty)

4 Replies
whiteline
Honored Contributor II

Re: Show Diemsion based on Column Results

Try to use column Expression insted of [ColumnName].

Also rewrite your expression like this:

=aggr(IF((ColumnExpression) > 0, ETMSpecialty), ETMSpecialty)

thomas_skariah
Contributor III

Re: Show Diemsion based on Column Results

Hi Martin,

Another option go for same query and check mark on "Suppress where value is null".

For your reference find the attached application.

Regards,

Tom

Not applicable

Re: Show Diemsion based on Column Results

I'll Try this thanks

Not applicable

Re: Show Diemsion based on Column Results

This worked with the suppress where value is null...

thanks my friends

Community Browser