topic Conditional Dimension in QlikView

Conditional Dimension

Tue, 23 Apr 2013 05:24:05 GMT

Hi All,

I need to list onlythe countries where sales is <= 0,

For that in Dimension i used like this but it not working,

if((Sum(Sales))<=0, Country) and in expression Sum(Sales)

What's wrong in this..

Thanks,

Selva

Re: Conditional Dimension

er_mohit — Tue, 23 Apr 2013 06:15:55 GMT

try this

aggr(if(Sales<=0,Country),fieldname) here fieldname you use that you want to get output on the basis of that

if you didnt get then,

use that in expression with using aggr function means on the basis of that field you want and try this

aggr(if(Sales<=0,Country),basefieldname)

Re: Conditional Dimension

Tue, 23 Apr 2013 06:24:13 GMT

Hi,

You can not aggregation function directly in dimention.

So use in dimension : if( Aggr(sum(Sales),Country) <=0,Country)

Niranjan M.

Re: Conditional Dimension

Anonymous — Tue, 23 Apr 2013 06:32:56 GMT

Hi Selvakumar

To list only the countries with sales<=0, You can change your expression as Sum(If(Sales<=0, Sales))

Hope it helps you

Regards

Revathy

Re: Conditional Dimension

Anonymous — Tue, 23 Apr 2013 07:21:13 GMT

Hi,

please find theattachment of application,zero will be supress to add a calulation dimension and in presentation tab supress zero check box will be check.

it will be work for you.

other wise please send the test data, i will work on the test data.

Regards

SHAIK

Re: Conditional Dimension

Tue, 23 Apr 2013 07:41:28 GMT

Hi All,

Thanks for the quick response

Both Mohit and Niranjan solution worked.

Selva

Re: Conditional Dimension

jagan — Tue, 23 Apr 2013 08:38:48 GMT

Hi Selva,

Try this using set analysis

=Sum({<Sales={'<=0'}>}Sales)

Hope this helps you.

Regards,

Jagan.