Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
The #1 reason QlikView customers adopt Qlik Sense is a desire for a modern BI experience. Read More
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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
Highlighted
Partner
Partner

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

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

Hope it works

View solution in original post

Highlighted
Creator
Creator

Thank you very much. It's works