topic Re: Show Diemsion based on Column Results in QlikView

Show Diemsion based on Column Results

Mon, 03 Sep 2012 08:53:02 GMT

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

whiteline — Mon, 03 Sep 2012 08:59:37 GMT

Try to use column Expression insted of [ColumnName].

Also rewrite your expression like this:

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

thomas_skariah — Mon, 03 Sep 2012 09:08:12 GMT

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

Mon, 03 Sep 2012 09:16:28 GMT

I'll Try this thanks

Mon, 03 Sep 2012 13:18:59 GMT

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

thanks my friends