topic Re: Set Analysis on a string value in QlikView

Set Analysis on a string value

Tue, 01 Mar 2016 23:34:58 GMT

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

Re: Set Analysis on a string value

sunny_talwar — Tue, 01 Mar 2016 23:43:18 GMT

Try this:

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

Re: Set Analysis on a string value

Tue, 01 Mar 2016 23:47:55 GMT

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?

Re: Set Analysis on a string value

Wed, 02 Mar 2016 00:31:42 GMT

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

Re: Set Analysis on a string value

Wed, 02 Mar 2016 00:32:10 GMT

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

Re: Set Analysis on a string value

sunny_talwar — Wed, 02 Mar 2016 00:34:51 GMT

Awesome

Re: Set Analysis on a string value

Wed, 02 Mar 2016 02:55:31 GMT

No worries Jordan