topic Limit values in Dimension in QlikView

Limit values in Dimension

Thu, 22 Jul 2010 09:31:40 GMT

Hello,

I'm creating a straight table. with a dimension. in this dimension, we have A, B , C, D.

How can i limit the dimension to only show B & C?

Thanks.

Limit values in Dimension

Thu, 22 Jul 2010 09:52:36 GMT

Hi,

I don't why do you want to use Straight table instead of Pivot table /chart when you have such criteria to follow.

Still, if you want in straight table, easier /simpler way will be create separate list box of dimension A,,B,C,D.

Choose whicheve dimension want in Straight table.

Happy Thoughts

Limit values in Dimension

Thu, 22 Jul 2010 09:53:34 GMT

Edit the dimension put condition according your requirement.

or on script you do same.

Regards

Ashish Srivastava

Limit values in Dimension

Thu, 22 Jul 2010 09:59:08 GMT

Hi Ravi

pivot table and straight table in my instance doesn't really help, because i still need to find a way to limit the value.

i tried script i tried condition, none of them work, if you have a script pattern in mind on how to limit, it'd be great if you could share?

Thanks.

Limit values in Dimension

Thu, 22 Jul 2010 10:09:26 GMT

Ok,

In that case, use pivot table.

Use "Name" A,B,C,D as Dimensions and apply condition for that dimension as follows:

IF(Name='B' or Name='C',Name,Null())

Also, tick on "Suppress Null values" in Dimensions.

Let me know if this serves the purpose.

Happy Thoughts

Limit values in Dimension

Thu, 22 Jul 2010 10:10:32 GMT

Hi nick,

Try something like:


[test]:
Load
Dimension
From database.xls (biff, embedded labels, table is Sheet1$)
where Dimension <> 'A' and Dimension <> 'D';

- Lester
 </body>

Limit values in Dimension

Thu, 22 Jul 2010 10:26:00 GMT

Hi Lester,

Nice option, it works, but i didn't want to affect my data.

So, my workaround is, in the straight table, in expression, use set analysis to limit the value you want to calculate, and it will remove the unwanted value for u.

Viola..

Limit values in Dimension

Thu, 26 Apr 2012 14:10:11 GMT

hi Nick,

If i follow your idea of handling from expression, all i see is one row for both dimension values (hear A and D) instead of two diffrent rows. Please correct me if i miss something.. ex:

Name Value

A 1000

D 2000

Tx.

Re: Limit values in Dimension

Thu, 26 Apr 2012 14:11:28 GMT

hi Nick,

If i follow your idea of handling from expression, all i see is one row for both dimension values (hear A and D) instead of two diffrent rows. Please correct me if i miss something.. ex:

Name Value

A 1000

D 2000

Tx.