topic How to restrict values with in a dimension in QlikView

How to restrict values with in a dimension

Wed, 20 Jun 2012 12:09:37 GMT

I use a straight table to display my data, I need to implement a where condition, like

This is my table

Col1 Col2 value

A x 1

B y 2,

Now i need to implement a where condition using qlikview scripts.

Any ideas will help me much.

Thanks,

Praveen.

Re: How to restrict values with in a dimension

Wed, 20 Jun 2012 12:14:39 GMT

What exactly do you want? Could you be more specific?

Re: How to restrict values with in a dimension

Wed, 20 Jun 2012 12:18:03 GMT

hi,

u can implement the where clause in backend, and if u want to implement some dondition to filter ur value in chart then u can do it in chart expression like u can write in expression defination

sum(if(Value>1,Value)) or any other expression.

even u can ristruct ur dimensions by adding the condition in Dimension>> Add calculated Dimensions.

I can help better if u can tell what condition u want to implement to ristrict value or

on what basis u want to ristrict the values.

Re: How to restrict values with in a dimension

Wed, 20 Jun 2012 12:21:54 GMT

My requirement is simple, I need to restrict values in one of the dimension i use for the straight table object.

For eg,

In the above table as i mentioned,

Show only where col1 = A and dont show the remaining, as exactly as like a where condition in a db.

Re: How to restrict values with in a dimension

Wed, 20 Jun 2012 12:26:27 GMT

hi,

U can write the condition in Dimension>>Add Calculated Dimension and write thr if(Col1='A',Col1).And put this dimension as the first Dimension in ur chart.

Re: How to restrict values with in a dimension

Wed, 20 Jun 2012 12:30:23 GMT

Hi pratibha,

I tried the same and i get the results like,

Col1 Col2 value

A x 1

- y 2,

I wanted to restrict the other rows and i need to display only this row.

Re: How to restrict values with in a dimension

Wed, 20 Jun 2012 12:36:17 GMT

Hi,

Please Tick the option in dimension tab "Suppress when the value is null" as done in Image attached.

Re: How to restrict values with in a dimension

Wed, 20 Jun 2012 12:38:45 GMT

Try this:

add a calculated dimension then "if(not IsNull(Col1),Col1)"

I hope this help