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: 
absekrafi
Creator III
Creator III

where clause in a set analisys clause

Dear community,

I am looking to find the minimum value of a date field called transaction_date where stock (an other field) is not null.

How can I achieve that?

Best regards,

Abdallah

1 Solution

Accepted Solutions
sunny_talwar

May be this?

Min({<stock = {"<>0"}>}transaction_date)

View solution in original post

5 Replies
surendraj
Specialist
Specialist

Try like...

Min({ $-<[Stock]={'*'}>}transaction_date)

OmarBenSalem

Maybe sthing like :

 

date(min (total {<Stock={"=len(trim(Stock))>0"}>} Transaction_Date))

sunny_talwar

May be this

Min({<stock = {"*"}>}transaction_date)
absekrafi
Creator III
Creator III
Author

Hi,

This expression returned dash(-) only not the minimum date where stock <> 0.

Best regards,

Abdallah

sunny_talwar

May be this?

Min({<stock = {"<>0"}>}transaction_date)