topic Re: Expression ??? in QlikView

Expression ???

Fri, 14 Feb 2014 11:58:15 GMT

Hi All,

I have a Straight Table object.

I need to Display the values of the table, where the Amount = 0.

Re: Expression ???

Fri, 14 Feb 2014 11:59:09 GMT

I need only fields, where the Amount = 0. Can anyone help me with the Expression ?

Thanks,

Praveen

Re: Re: Expression ???

manojkulkarni — Fri, 14 Feb 2014 12:07:56 GMT

Check attached file..

Re: Re: Expression ???

sundarakumar — Fri, 14 Feb 2014 12:08:17 GMT

PFA

Re: Expression ???

MK_QSL — Fri, 14 Feb 2014 12:09:58 GMT

Use

=if(SUM(Amount)<>0,SUM(Amount)) as Expression and

In Presentation tab

Select Supress Zero Values

This one will give you non-zero

Sorry My Mistake...

=if(SUM(Amount)=0,SUM(Amount)) as Expression and

make sure in Presentation Tab

Supress Zero Values not selected

This one give you zoro

Re: Re: Expression ???

sundarakumar — Fri, 14 Feb 2014 12:14:04 GMT

Hi Praveen,

Manoj have used script whereas i have done the same with calculated dimension.

It is better to use edit scrit since calculated dimension can reduce your performance if u have lot of data.

Sundar

Re: Expression ???

nizamsha — Fri, 14 Feb 2014 12:19:23 GMT

Try this in this dimension

=Aggr( if(sum(Amount)<=0, Name),Name)

Re: Expression ???

Fri, 14 Feb 2014 12:50:04 GMT

Hi Manish,

I too tried in the same way

=if(SUM(Amount)=0,SUM(Amount)) as Expression and

make sure in Presentation Tab

Supress Zero Values not selected

It is showing fields which have zero. But it is also displaying the Nonzero values as '-'. I wanted to Suppress the non zero rows as well.

Re: Expression ???

Fri, 14 Feb 2014 12:55:00 GMT

Hi Manish,

I used ur second Expression.

It is displaying the Field values where Amount =0. Its good. But it is also displaying other rows where amount = non zero. It is dioslpaying those row's value as '-'

Re: Re: Expression ???

MK_QSL — Fri, 14 Feb 2014 12:59:05 GMT

Check enclosed file... Hope this might help you.

Re: Expression ???

Fri, 14 Feb 2014 13:01:04 GMT

Thanks Nizam

Re: Expression ???

Fri, 14 Feb 2014 13:43:15 GMT

Thanks Manish.

Its working

Re: Expression ???

veeranj — Mon, 17 Feb 2014 07:16:22 GMT

Hi,

It can also be done by using the expression as
only({<Amount={0}>}Amount) and add SNO and Name as dimensions .
Then it will display those rows where Amount field was ZERO

Anjee