Dynamic Dimension based on value in column

ManuelRühl — Fri, 19 Nov 2010 12:07:02 GMT

<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>

Dynamic Dimension based on value in column

Anonymous — Fri, 19 Nov 2010 12:19:01 GMT

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

AW:Re: Dynamic Dimension based on value in column

ManuelRühl — Fri, 19 Nov 2010 12:32:26 GMT

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.

Dynamic Dimension based on value in column

Anonymous — Fri, 19 Nov 2010 12:44:10 GMT

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

topic Dynamic Dimension based on value in column in QlikView

Dynamic Dimension based on value in column

Dynamic Dimension based on value in column

AW:Re: Dynamic Dimension based on value in column

Dynamic Dimension based on value in column