topic Re: Straight table values in QlikView

Straight table values

Wed, 08 Jul 2015 14:32:48 GMT

Hello everyone,

I have a straight table with a set analysis expression. I would like to show only values that are larger than X. how can I do that?

I tried to change the expression to a dimension (I wanted to add condition and suppress when value is null) but there's an error in the set analysis calculates dimension.

any other ideas?

Thanks

Re: Straight table values

alexandros17 — Wed, 08 Jul 2015 14:36:53 GMT

Let's say tour expression is Expr1 then write:

If(Expr1 > X, Expr1, 0)

as default, all zera values are excluded (if you have more than one expression (es. expr2) you have to write in expr2:

If(Expr1 > X, Expr2, 0)

So all expression will turn to zero if expr1 condition is not satisfied

Re: Straight table values

Wed, 08 Jul 2015 14:39:18 GMT

you want not to show some rows with small data?

well, for example, if you have an expression (exp) you can change it (or create second one and hide the first one) like

if(exp > X, exp, 0)

rows with this 0 will go away

Re: Straight table values

Wed, 08 Jul 2015 15:01:27 GMT

Thanks for the quick response

it's not working(still shows the 0 values) my straight table looks like this:

3 dimensions (HotelID which is a calculated dimension, hotel name and city name)

and the following expressions:

1. Gross LM: sum(gross)

2. Gross LM same country(the set analysis expression):

sum({1<Agency_Country=P(Agency_Country)>}Gross_LM)

3. flag

i only want to show Hotels where expression No. 2 is larger than X.

Re: Straight table values

antoniotiman — Wed, 08 Jul 2015 15:17:20 GMT

Hi,

You need Calculated Dimension like this

Aggr(If(Sum(Gross_LM) > X,HotelID),HotelID,Agency_Country)

Can You share sample data ?

Regards