topic Re: Set Analysis Greater Then left Column value in QlikView

Set Analysis Greater Then left Column value

Wed, 23 Jul 2014 07:52:07 GMT

Hello,

is it possible to write an Set Analysis Expression like this:

I want to count all orders from date in Column min_order_date for every customer.

Any idea?

Thanks.

Re: Set Analysis Greater Then left Column value

MK_QSL — Wed, 23 Jul 2014 07:53:16 GMT

What is Order_Date and What is Min_Order_Date ?

If possible, please provide some few lines sample data.

Re: Set Analysis Greater Then left Column value

Wed, 23 Jul 2014 07:57:47 GMT

min_order_date=Min({1<order_id=P({1<product_id={'$(=Only(product_id))'}>} order_id)>} order_date)

:: It is a first Order-Date from Customer who buy a specific product.

My SRC looks like this:
customer_id,order_id,order_date,product_id

Re: Set Analysis Greater Then left Column value

MK_QSL — Wed, 23 Jul 2014 07:59:01 GMT

Would like to try this if you can provide some sample data...

Re: Set Analysis Greater Then left Column value

lironbaram — Wed, 23 Jul 2014 08:14:02 GMT

set expression won't work

because in set analysis you'll find the min date of all customers and products

set analysis returns the same value to all the rows in the chart

why not use the column you created in the chart in the next expression

Re: Set Analysis Greater Then left Column value

sujeetsingh — Wed, 23 Jul 2014 08:15:47 GMT

If will be the best way to do this.

If possible please send a sample.

Re: Re: Set Analysis Greater Then left Column value

Wed, 23 Jul 2014 08:16:42 GMT

sample file

Thank You

Re: Re: Set Analysis Greater Then left Column value

Wed, 23 Jul 2014 08:20:27 GMT

sample file is uploaded

Re: Set Analysis Greater Then left Column value

Wed, 23 Jul 2014 08:22:40 GMT

That's what I already suspected

Re: Set Analysis Greater Then left Column value

MK_QSL — Wed, 23 Jul 2014 08:23:31 GMT

Set Analysis will not work but need to find some trick ...!

Re: Set Analysis Greater Then left Column value

Wed, 23 Jul 2014 08:31:09 GMT

Do you have any Trick-Idea?

Re: Set Analysis Greater Then left Column value

simondachstr — Wed, 23 Jul 2014 08:35:34 GMT

This also works

count(Order_id)*(min_order_date<Order_date)*-1

Re: Re: Set Analysis Greater Then left Column value

lironbaram — Wed, 23 Jul 2014 08:45:50 GMT

hi have a look at the attach example

Re: Set Analysis Greater Then left Column value

Wed, 23 Jul 2014 08:48:05 GMT

For me, unfortunately not.