Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
If you are a Qlik Insight Bot user, join this collaborative group: JOIN GROUP
New Contributor III

Problem with the range

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

S

Tags (2)
12 Replies
Highlighted
Partner
Partner

Re: Problem with the range

Hi Shashank,

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

Highlighted
Not applicable

Re: Problem with the range

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

Highlighted
Contributor III

Re: Problem with the range

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

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

Highlighted
New Contributor III

Re: Problem with the range

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

Highlighted
New Contributor III

Re: Problem with the range

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

Highlighted
Partner
Partner

Re: Problem with the range

Hi,

Find the attchment and this is the change

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

Highlighted
New Contributor III

Re: Problem with the range

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,

S

Highlighted
MVP
MVP

Re: Problem with the range

are the ranges symmetrical?

If yes, you can use class function...

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

Highlighted
Not applicable

Re: Re: Problem with the range

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))