topic Re: Problem with the range in QlikView

Problem with the range

Anonymous — Mon, 03 Feb 2014 06:05:42 GMT

Hi Genuises,

I have a chart in which I have Customer Code, Local Cargo Throughput

Expression as Sum(Cargo_thruput)

Below is the image of the chart attached

Please open the image and then go thru the below problem

So if you see I have range for Local CArgo throughput which is 1-300000 and >300000 these ranges are coming from an excel files

Now when I am doing the Sum(Cargo_thruput) in whichever range it will lie it has to be there in image case if you see Customer Code= CSTEINWEG SUm is 4255376 but it is lying in both the places 1-300000 and >300000 , I need that it will lie only to >300000 and the other row will be eliminated

Please look only for CSTEINWEG

Fast help will be appreciated as I have to deliver it in 2 hours

Thanks in advance

Re: Problem with the range

jvishnuram — Mon, 03 Feb 2014 06:30:01 GMT

Hi Shashank,

If possible could you please post your sample application., because that will helpful to play around.

Re: Problem with the range

Mon, 03 Feb 2014 06:32:22 GMT

Can you please attach a sample app for this. This will help you give faster feedback from community

Re: Problem with the range

iktrayanov — Mon, 03 Feb 2014 06:39:47 GMT

Instead of using Local Cargo Throughput from Excel use a calculated dimension like

If(Sum(Cargo_thruput)<=300000,'1-300000','>300000')

Re: Problem with the range

Anonymous — Mon, 03 Feb 2014 06:42:56 GMT

Attached is the sample app

here the Customer Code =CSTEINWEG Sum(Cargo_thruput) is 52180 so it should lie in the range 1-300000 and the other range should be removed

Re: Problem with the range

Anonymous — Mon, 03 Feb 2014 06:45:14 GMT

I have to take the ranges from the excel because each time these ranges will be changed by the client

Re: Problem with the range

jvishnuram — Mon, 03 Feb 2014 06:48:20 GMT

Hi,

Find the attchment and this is the change

=If(Aggr(Sum(CARGO_TONNAGE),[Local Cargo Throughput])<=300000,'1-300000','>300000')

Re: Problem with the range

Anonymous — Mon, 03 Feb 2014 07:00:52 GMT

Hi Vishnu,

Thanks for the quick response, but real problem is that these ranges are coming from excel which will change each quarter and there are 100 of ranges, you are only able to see two ranges as I have loaded only one excel

Thanks,

Re: Problem with the range

MK_QSL — Mon, 03 Feb 2014 07:03:30 GMT

are the ranges symmetrical?

If yes, you can use class function...

=Replace(Class(Aggr(Sum(CARGO_TONNAGE),[Customer Code]),3000000),'<= x <','-')

Re: Re: Problem with the range

Mon, 03 Feb 2014 07:12:37 GMT

Hello,

Can you please find the attachment. It will make the stuff more dynamic. But for now I have added that in expression, you can play around with this approach further.

Hope it is helpful.

Thanks,

Angad

P.S :

In the Flag expression please use below:

if(not isnull([Local Cargo Throughput]),if(Sum(CARGO_TONNAGE)>= LowerRange and Sum(CARGO_TONNAGE) <= UpperRange,1,0))

Re: Problem with the range

Anonymous — Mon, 03 Feb 2014 07:31:03 GMT

Hi Manish,

Thanks for the response.

No Classes are not symmetrical

Re: Re: Problem with the range

Anonymous — Wed, 05 Feb 2014 09:25:28 GMT

Hi Angad,

Thanks for the answer , its working fine when I have a range like

1 - 250000 or > 250000

The problem is when I have the range like

25000 - 30000 , 30000-90000

Please help me out and after that I will mark this as correct answer

pls

Thanks,

Re: Problem with the range

Wed, 05 Feb 2014 10:56:40 GMT

I think it should work with those ranges as well.

For any range,

It is reading the '-' or '>'and then separating lower and upper ranges.

Can you please modify the attachment I sent, with what issues you are having.

Thanks,

Angad