Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
andrea90casa
Creator
Creator

Expression Set Analysis

Hi at all,

I have a dataset with one field called data and another one called unit price

I would like to create a formula that shows me the first available unit price for a specific product, i have created a variable called MinData with this formula =Min(data)

And then i wanted to try this one

Avg({<data = $(=MinData)>}Unit_Price)

But it doesn't work, anyone can help me with this..

Best regards

Andrea

11 Replies
krishnacbe
Partner - Specialist III
Partner - Specialist III

MinData variable settings I have added expression as =Date(Min(data))

avg({<data={"$(MinData)"}>}Unit_Price)

Hope it works

andrea90casa
Creator
Creator
Author

Thank you very much. It's works