topic FirstSortedValue in set analysis in QlikView

FirstSortedValue in set analysis

AndreFrencl — Sat, 16 Nov 2024 01:24:09 GMT

Hi, guys.

My set analysis:

sum({<_C3Meses_VENDAS_={1},DES_CD={'$(=FirstSortedValue(DES_CD,-(aggr(sum({<_C3Meses_VENDAS_={1}>}VB),DES_CD,BANDEIRA)),1))'}>}VB)

don't work.

if i isolate the expression //// =FirstSortedValue(DES_CD,-(aggr(sum({<_C3Meses_VENDAS_={1}>}VB),DES_CD,BANDEIRA)),1)) //// , it work normally.

any sugestion?

thz!

André

Re: FirstSortedValue in set analysis

jberna26 — Tue, 28 Jan 2020 21:28:47 GMT

Hi @AndreFrencl ,

can you give us an example of what you are trying to achieve? And what kind of data?

Usually, in my experience, FirstSortedValue is more commonly used to get a string, which you cannot sum, otherwise you would use the Max function.

If you can give us examples maybe we can help 😉

Re: FirstSortedValue in set analysis

AndreFrencl — Wed, 29 Jan 2020 10:41:49 GMT

hi, @jberna26

the function

=FirstSortedValue(DES_CD,-(aggr(sum({<_C3Meses_VENDAS_={1}>}VB),DES_CD,BANDEIRA)),1))

the function bring to me a string, like "RS", "AP", "CO", ....

so, my goal is like this:

sum({<_C3Meses_VENDAS_={1},DES_CD={'RS'}>}VB)

both functions works, but not together.

(sorry my english)

Re: FirstSortedValue in set analysis

jberna26 — Wed, 29 Jan 2020 11:30:04 GMT

Hi @AndreFrencl ,

I understood now what you are trying to achieve.

You should use double quotes:

sum({<_C3Meses_VENDAS_={1},DES_CD={"$(=FirstSortedValue(DES_CD,-(aggr(sum({<_C3Meses_VENDAS_={1}>}VB),DES_CD,BANDEIRA)),1))"}>}VB)

Not sure it will fix the problem, but single quotes are reserved for literal strings, and double quotes are used when some kind of search or function is applied.

Let me know if it fixes the issue.

Regards