topic How to use greater than in set analysis using a single variable? in QlikView

How to use greater than in set analysis using a single variable?

Wed, 05 Mar 2014 04:19:04 GMT

Hi All,

I am working on a outstanding report.

User will input different outstading days which will be stored in a variable "vOutStandingDays".

This variable is used to show the outstanding amount in a text object.

=num(Sum({<VehicleSparesType={'Vehicle Sales'},OutStandinfDiff={'>=$(vOutstandingDays'}, BusinessArea={'CA01'}>} Outstanding)/10000000,'###,##,##,###.00')

But it does not give me any output.

Please help for "how to use greater than only in set analysis using one variable'

Thanks in advance.

Re: How to use greater than in set analysis using a single variable?

tresB — Wed, 05 Mar 2014 05:12:11 GMT

Missing a closing parenthesis after variable:

'>=$(vOutstandingDays)'}

Re: How to use greater than in set analysis using a single variable?

MK_QSL — Wed, 05 Mar 2014 07:07:12 GMT

=num(Sum(

{$<

VehicleSparesType={'Vehicle Sales'},

OutStandinfDiff={'>=$(vOutstandingDays)'},

BusinessArea={'CA01'}

Outstanding)/10000000,'###,##,##,###.00')

Re: How to use greater than in set analysis using a single variable?

jagan — Wed, 05 Mar 2014 07:31:25 GMT

Hi,

Try like this

=num(Sum({<VehicleSparesType={'Vehicle Sales'},OutStandinfDiff={'>=$(=vOutstandingDays)'}, BusinessArea={'CA01'}>}Outstanding)/10000000,'###,##,##,###.00')

Regards,

Jagan.

Re: How to use greater than in set analysis using a single variable?

sunilkumarqv — Wed, 05 Mar 2014 08:01:05 GMT

Hi Sarang

try like this

=num(Sum({<VehicleSparesType={'Vehicle Sales'},OutStandinfDiff={"<=$(=vOutstandingDays)"}, BusinessArea={'CA01'}>}Outstanding)/10000000,'###,##,##,###.00')