Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Set Analysis Greater Then left Column value

Hello,

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

MIN_ORDER_DATE.jpg

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

Any idea?

Thanks.

1 Solution

Accepted Solutions
lironbaram
Partner - Master III
Partner - Master III

hi have a look at the attach example

View solution in original post

13 Replies
MK_QSL
MVP
MVP

What is Order_Date and What is Min_Order_Date ?

If possible, please provide some few lines sample data.

Not applicable
Author

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

MK_QSL
MVP
MVP

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

lironbaram
Partner - Master III
Partner - Master III

hi

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

sujeetsingh
Master III
Master III

If will be the best way to do this.

If possible please send a sample.

Not applicable
Author

sample file

Thank You

Not applicable
Author

sample file is uploaded

Not applicable
Author

That's what I already suspected

MK_QSL
MVP
MVP

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