topic Re: Straight Table Record Filter in QlikView

Straight Table Record Filter

Wed, 15 Oct 2014 08:24:48 GMT

Dear all,

I have a straight table displaying the data. one of the column in the table is QTY. How do i get the straight table display the QTY > 0 automatically without user selection.

I have tried to add a calculated dimension but it seems not working. Thank you

Re: Straight Table Record Filter

maleksafa — Wed, 15 Oct 2014 08:27:18 GMT

add it to your expression filter and not the dimension, sum({<QTY>0>} Expression) or add an if condition to your expression, for example if (sum(QTY) >0,1,0).

Re: Straight Table Record Filter

Anonymous — Wed, 15 Oct 2014 08:27:42 GMT

try with

=if( yourQTDexpression >0, yourQTDexpression )

Marc.

Re: Straight Table Record Filter

Wed, 15 Oct 2014 08:30:12 GMT

hi marc,

Are you saying add this at the dimension or expression?

Re: Straight Table Record Filter

jagan — Wed, 15 Oct 2014 08:32:39 GMT

Hi,

Try this expression

If(Sum(QTY) > 0, Sum(QTY))

Regards,

Jagan.

Re: Straight Table Record Filter

Anonymous — Wed, 15 Oct 2014 08:34:08 GMT

In the expression, so yo will get value only when QTY>0.

Is this what you expected?

Re: Straight Table Record Filter

ashfaq_haseeb — Wed, 15 Oct 2014 08:35:11 GMT

Add this in expression

if(sum(QTY) >0, sum(QTY) )

Regards

ASHFAQ

Re: Straight Table Record Filter

Wed, 15 Oct 2014 08:40:09 GMT

if i add this if(sum(QTY) >0, sum(QTY) ), it doesn't filter the row where qty is 0. it just show with a hyphen. what i want the row completely not show if the qty is 0

Re: Straight Table Record Filter

jagan — Wed, 15 Oct 2014 08:42:34 GMT

Hi,

In the first expression give like this

if(sum(QTY) >0, Your Expression)

Hope this helps you.

Regards,

Jagan.

Re: Straight Table Record Filter

Wed, 15 Oct 2014 08:47:35 GMT

hi mogan,

As mentioned in the screenshot before your reply. The expression doesnt help as it still shown the QTY=0 row. It just give hypen on the QTY field only.

What i wanted is the entire row not showing as long at the QTY=0

Re: Straight Table Record Filter

ashfaq_haseeb — Wed, 15 Oct 2014 08:48:19 GMT

make sure that is your first expression

Regards

ASHFAQ

Re: Straight Table Record Filter

Wed, 15 Oct 2014 08:51:54 GMT

It's in the first expression.

Re: Straight Table Record Filter

ashfaq_haseeb — Wed, 15 Oct 2014 08:58:07 GMT

What does your second expression contain?

Can you post sample application.

Regards

ASHFAQ

Re: Straight Table Record Filter

Anonymous — Wed, 15 Oct 2014 08:59:58 GMT

Then you will have to make it in dimension:

=aggr({<QTY={">0"}>} dimension)

Marc.

Re: Straight Table Record Filter

Wed, 15 Oct 2014 09:14:54 GMT

Hi March,

I guess what your suggest is correct. I unable to rewrite the aggr function. my field name is ji_shortqty. The dimension is ji_ID.

How do i rewrite based on your answer?

Re: Straight Table Record Filter

jagan — Wed, 15 Oct 2014 09:15:59 GMT

Hi,

Change your second expression like this

if(sum(QTY) >0, 'Your Second Expression goes here')

Regards,

Jagan.

Re: Re: Straight Table Record Filter

Anonymous — Wed, 15 Oct 2014 09:25:09 GMT

Check attached.

Marc.

Re: Re: Straight Table Record Filter

Wed, 15 Oct 2014 09:30:25 GMT

marc,

I have used the formula given. Suprisingly, the formula has the red underline which usually indicate wrong formula. But it actually correct as you can see the word 'OK' May i know how come like that?

Re: Re: Re: Straight Table Record Filter

Anonymous — Wed, 15 Oct 2014 09:39:15 GMT

The expresion is ok and working fine, as you can see in the sample qvw i posted before.

Re: Re: Re: Straight Table Record Filter

Anonymous — Wed, 15 Oct 2014 10:38:21 GMT

Chee Hang Lim,

Could you solve it? Don't forget to select an answer as useful / correct if it was so for you.

Marc.