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 on a string value

Hi,

I need to be able to do set analysis on a string.

I have a string value called Core Product which is a "Yes" or "No" field. I need to be able to do set analysis / filter based on a Transaction Date field to be able to get the latest record.

EG:

Transaction Date               Core Product

01/02/2016                         Yes

03/02/2016                         No

05/02/2016                         Yes

I need to be able to get the last record..

Because Core Product is a string, I am unable to use sum or max.

What should I use?

Thanks

Jordan

1 Solution

Accepted Solutions
sunny_talwar

Try this:

=FirstSortedValue([Core Product], -[Transaction Date])

View solution in original post

6 Replies
sunny_talwar

Try this:

=FirstSortedValue([Core Product], -[Transaction Date])

Not applicable
Author

Hi Jordan,

Can you please explain more about what you are trying to achieve? I am little confused and don't want to give incorrect solution.

What last record you want to get? Latest date when a Core Product was YES? or Total of core products?

Not applicable
Author

Hi Lokesh,

Sunny has answered my question, thanks though.

I was wanting to get the newest Core Product based on the latest transaction date. In my example it would be 05/02/2016 - Yes.

Thanks

Jordan

Not applicable
Author

Thanks Sunny for your help, that is exactly what I wanted.

sunny_talwar

Awesome

Not applicable
Author

No worries Jordan