topic Re: Another Set Analysis Question in QlikView

Another Set Analysis Question

Wed, 16 Apr 2014 16:59:21 GMT

Hi all,

I am working on this report and I am running into a wall.

This report asks the user to select a State, City, and then a store. Based off that selection it lists other stores near by and calculates the distance from the selected store.

It works great.

But here is the issue, I am trying to do a count of orders at the stores listed by doing the following:

=if($(vCalc) > 0 and $(vCalc) <=$(vRadius),Sum(Orders_Counter))

in an expression. This is a straight table which I'll eventually turn into a like graph. The dimension are the StoreNames.

The issue is that that expression alone wont allow the data to show. But I need to add another expression with just one inside it to get the storenames and the =if($(vCalc) > 0 and $(vCalc) <=$(vRadius),Sum(Orders_Counter)) to even show in the straight table.

Is there another way around adding this extra expression?

Re: Another Set Analysis Question

its_anandrjs — Wed, 16 Apr 2014 17:04:06 GMT

You can try this

Sum(if($(vCalc) > 0 and $(vCalc) <=$(vRadius) , Orders_Counter))

Re: Another Set Analysis Question

Wed, 16 Apr 2014 17:29:42 GMT

I think that I would need to ignore selected:

SUM(if($(vCalc) > 0 and $(vCalc) <=$(vRadius),{<StoreName = >} Orders_Counter))

But the above is not getting it either

Re: Another Set Analysis Question

Wed, 16 Apr 2014 17:33:36 GMT

Got it

if($(vCalc) > 0 and $(vCalc) <=$(vRadius), SUM({<StoreName = >} OrderTest_Counter))