Dynamic Dimension based on value in column - Qlik Community

mruehl · ‎2010-11-19

<body>I want to limit the dimension, based on a value in a column. I need a calculated dimension like: IF(COLUMN(1)='X',DIMENSION_NAME,NULL()) <tr style="height: 12.75pt;" height="17"> <td style="border-left: none; width: 74pt;" width="98" class="xl22"></td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt; border-top: none;" align="right" class="xl23" height="17"></td> <td style="border-top: none; border-left: none;" class="xl23"></td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt; border-top: none;" align="right" class="xl23" height="17"></td> <td style="border-top: none; border-left: none;" class="xl23"></td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt; border-top: none;" align="right" class="xl23" height="17"></td> <td style="border-top: none; border-left: none;" class="xl23"></td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt; border-top: none;" align="right" class="xl23" height="17"></td> <td style="border-top: none; border-left: none;" class="xl23"></td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt; border-top: none;" align="right" class="xl23" height="17"></td> <td style="border-top: none; border-left: none;" class="xl23"></td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt; border-top: none;" align="right" class="xl23" height="17"></td> <td style="border-top: none; border-left: none;" class="xl23"></td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt; border-top: none;" align="right" class="xl23" height="17"></td> <td style="border-top: none; border-left: none;" class="xl23"></td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt; border-top: none;" align="right" class="xl23" height="17"></td> <td style="border-top: none; border-left: none;" class="xl23"></td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt; border-top: none;" align="right" class="xl23" height="17"></td> <td style="border-top: none; border-left: none;" class="xl23"></td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt; border-top: none;" align="right" class="xl23" height="17"></td> <td style="border-top: none; border-left: none;" class="xl23"></td> </tr> </body>

Anonymous · ‎2010-11-19

if your real sistuation is simple as you posted you can simply

write a dimension like:

=IF(A>5,A) and suppress it if it's equal to null.

If your reality is more complex (more dimensions...) you may try something like that, but using the "aggr" function on other dimensions involved in the calculation...

regards

Matteo

mruehl · ‎2010-11-19

the situation is more complex.

the value in the column is calculated based on values in other columns.

so the calculation in the dimension makes reporting very slow.

i want to show the row, based on a calculated calue in a column.

Anonymous · ‎2010-11-19

I generally solve this situation solving the problem in the script.

I must compute your dimension in the script, so your application will result faster, especially if you work with a huge amount of data.

regard Matteo