topic Re: How not to include dimension in table when it equals a certain value in QlikView

How not to include dimension in table when it equals a certain value

Fri, 04 May 2012 14:38:15 GMT

Hi Community, I have a calculated dimesion that equals -1 and 0. When its 0 I don't want it in my table and don't want it to contribute to the sum. Any thoughts?

How not to include dimension in table when it equals a certain value

Fri, 04 May 2012 14:59:02 GMT

Can you attach a sample .qvw so we can help you.

Thanks.

Regards.-

Re: How not to include dimension in table when it equals a certain value

vincent_ardiet — Fri, 04 May 2012 15:08:39 GMT

Hi,

You can use a set analysis, for example :

=sum({$<MyDimension={'-1'}>} Qty)

This formula will only take in account Qty when MyDimension=-1

Of course MyDimension must be calculated in the script.

Else, if the dimension is calculated in the chart, instead of returning 0, you can use null() and then choose to supress null value with the checkbox below the dimension.

Regards,

Vincent

Re: How not to include dimension in table when it equals a certain value

chematos — Fri, 04 May 2012 18:37:40 GMT

Hi, with the permission of Vincent and using his example, you could use the operator '-=' to get all values except the value or values you want to choose.

=sum({$<MyDimension -= {0}>} Qty)

Although may be you are looking for an if statement:

If(CalculateDimension <>0, Dimension)

Regards,

Chema

Re: How not to include dimension in table when it equals a certain value

CELAMBARASAN — Fri, 04 May 2012 18:54:36 GMT

Hi,

Can you post the expression you used for calculated dimension?

Celambarasan

Re: How not to include dimension in table when it equals a certain value

Mon, 07 May 2012 20:13:42 GMT

I would but I actually used it in my script load. I could give you that instead:

if(leafhdrtxt='AERO' and el1='2000',PeriodTotal,if(leafhdrtxt='INCOME TAXES' and el1='2000',PeriodTotal,if(leafhdrtxt='OTHER INCOME (EXPENSE)' and el1='2000',PeriodTotal,if(leafhdrtxt='NON CONT INTEREST' and el1='2000',PeriodTotal,if(leafhdrtxt='Administrative expense' and el1='2000',PeriodTotal,if(leafhdrtxt='EFD' and el1='1000',PeriodTotal,if(leafhdrtxt='ESD' and el1='4000',PeriodTotal,if(leafhdrtxt='ATD' and el1='4700',PeriodTotal,if(leafhdrtxt='INCOME TAXES' and el1='4700',PeriodTotal,if(leafhdrtxt='OTHER INCOME (EXPENSE)' and el1='4700',PeriodTotal,if(leafhdrtxt='ELIM' and el1='9900',PeriodTotal,if(leafhdrtxt='INCOME TAXES' and el1='9900',PeriodTotal,if(leafhdrtxt='Administrative expense' and el1='9000',PeriodTotal,if(leafhdrtxt='INCOME TAXES' and el1='9000',PeriodTotal,if(leafhdrtxt='OTHER INCOME (EXPENSE)' and el1='9000',PeriodTotal))))))))))))))) as t,