topic I need to convert this espression in a set analysis expression in QlikView

I need to convert this espression in a set analysis expression

Mon, 12 Mar 2012 11:04:43 GMT

Here you are the normal expression:

COUNT(IF(week_ship=week_ship_2, orders))

I tried with this one ... but it doesn't work:

COUNT({1<week_ship={$(=ONLY(week_ship_2))}>} orders)

Anybody ?

Thanks in advance

I need to convert this espression in a set analysis expression

swuehl — Mon, 12 Mar 2012 11:18:23 GMT

I assume you want a record based comparison, try

=COUNT({1<week_ship = {"=week_ship=week_ship_2"}>} orders)

I need to convert this espression in a set analysis expression

Mon, 12 Mar 2012 11:31:28 GMT

thanks but it doesn't work ... I mean if I select week_ship_2 I get a result ... but it's completely different from the result that I want from the first formula.

I need to convert this espression in a set analysis expression

Mon, 12 Mar 2012 11:32:52 GMT

BTW : week_ship adn week_ship_2 are two fields

I need to convert this espression in a set analysis expression

Mon, 12 Mar 2012 11:33:48 GMT

Hi tode,

You can try dis,

COUNT({$<week_ship = {'week_ship=week_ship_2'}>} orders)

I need to convert this espression in a set analysis expression

swuehl — Mon, 12 Mar 2012 11:34:09 GMT

Ok, so week_ship and week_ship_2 are not two columns in the same table?

How are they related? What do you want to achieve in a "big picture"?

I need to convert this espression in a set analysis expression

Mon, 12 Mar 2012 11:47:54 GMT

No they are not two columns of the same table ... they come from two different tables but the two tables are linked through orders (anyway the number of the order)

I need to convert this espression in a set analysis expression

swuehl — Mon, 12 Mar 2012 11:53:05 GMT

And you can have multiple week_ship and week_ship_2 per order?

If yes, how to handle these cases?

Could you give some sample lines of data together with your expected outcome?

I need to convert this espression in a set analysis expression

Mon, 12 Mar 2012 13:26:35 GMT

These are the two fields.

Anyway ... are there others way to convert COUNT(IF(week_ship=week_ship_2, orders))

in a set analysis ?

Re: I need to convert this espression in a set analysis expression

swuehl — Mon, 12 Mar 2012 13:35:58 GMT

I was more thinking of an example demonstrating your table / field relations like

LOAD * INLINE [

Order, week_ship

1, 1

1, 2

2, 3

3, 4

];

LOAD * INLINE [

Order, week_ship_2

1, 2

2, 3

3, 3

];

And then an example of how you use your expression (in which context, chart object - any information that might help).

I need to convert this espression in a set analysis expression

Mon, 12 Mar 2012 13:45:21 GMT

You got my situation with your example. But really I cannot get why all the time the result is 0 with the set analysis while I have a different result with the standard formula with if.

I thouth to use the function P() ... I got a result but it's different from my original formula

I need to convert this espression in a set analysis expression

swuehl — Mon, 12 Mar 2012 13:48:14 GMT

Have you checked my attachment? There I use both expressions with same result.

Could you maybe post an example that demonstrates your problem or modify mine?

I need to convert this espression in a set analysis expression

Mon, 12 Mar 2012 14:03:30 GMT

I saw you attachament ... and really is fine

My formula is:

And is very similar to yours but I get just 0 as results

(I posted Images so nobody can seek this formulas on google)

I cannot understand way.

I tried with P() as well, I got a result but it's not the desired one.

I need to convert this espression in a set analysis expression

Mon, 12 Mar 2012 14:17:12 GMT

AND IF IT HELPS i AM USING THIS EXPRESSION IN A GAUGE CHART

I need to convert this espression in a set analysis expression

swuehl — Mon, 12 Mar 2012 14:37:11 GMT

Not sure where your arrows in your first image point to, definitely not to SETTIMANA_SPEDIZIONE or ...SETTIMANA_DELIVERY.

But anyway, you are using single quotes in your element_set, instead of double quotes.

Use ....={"=week_ship=week_ship_2"}

I need to convert this espression in a set analysis expression

Mon, 12 Mar 2012 14:41:10 GMT

Believe me ...the two weeks column are located in those two tables.

I tried with and not the " or ' without any result. I am sure that your solution works fine ....but I cannot really get why I am unable to the same in the gauge chart of my document.

I need to convert this espression in a set analysis expression

swuehl — Mon, 12 Mar 2012 14:48:45 GMT

So the expression works in your app in a straight table / text object?

You only have problems using it in a gauge chart? Well, I can use the expression in a gauge chart, so you must do it in a different way / setting. But you are always a bit short in giving more informations which makes it quite hard to help you. Could you please describe your setting a bit closer (dimensions / expressions etc.).

Again, providing a small sample app would really help me to help you.

Re: I need to convert this espression in a set analysis expression

Mon, 12 Mar 2012 15:00:01 GMT

This is an example also here my result is 0

Re: I need to convert this espression in a set analysis expression

Mon, 12 Mar 2012 15:01:34 GMT

It doesn't matter if I use "

Re: I need to convert this espression in a set analysis expression

gandalfgray — Mon, 12 Mar 2012 15:09:45 GMT

Try:

=COUNT({$<week1 = P(week2)>} DISTINCT week1)

if you want to count "matching weeks"

/GandalfGray