topic Set Analysis in QlikView

Set Analysis

chriys1337 — Tue, 17 Jan 2017 15:59:34 GMT

Hi all,

I have loaded a index with some dates and the specific index value at this time.

Now I just would like to see the latest index and tried to find a solution with Set Analysis, which looks like this:

=only({$<date={$(=max(date))}>}Index)

Unfortunately it does not work, the textbox says "Error: Error in set modifier ad hoc element list: '.' or ')' expected.

Does anybody find my mistake in building the set analysis expression?

Thank you.

Re: Set Analysis

krishnacbe — Tue, 17 Jan 2017 16:03:37 GMT

Try below expression.

=only({$<date={"=$(=max(date))"}>}Index)

Re: Set Analysis

sunny_talwar — Tue, 17 Jan 2017 16:05:32 GMT

Try with Single or double quotes

=Only({$<date={'$(=max(date))'}>}Index)

=Only({$<date={"$(=max(date))"}>}Index)

Re: Set Analysis

chriys1337 — Tue, 17 Jan 2017 16:06:32 GMT

That's right, thank you. Whats the reason for this?

Re: Set Analysis

sunny_talwar — Tue, 17 Jan 2017 16:07:31 GMT

Read here:

A Primer on Set Analysis

Re: Set Analysis

chriys1337 — Thu, 02 Feb 2017 08:41:38 GMT

I am trying a similar thing today, but unfortunately it does not work anymore? Does somebody see the mistake?

=only({$<Index_YearWeek={"=$(=max(Index_YearWeek))"}>}Index_CFI)

Re: Set Analysis

sunny_talwar — Thu, 02 Feb 2017 09:45:09 GMT

What is Index_YearWeek field's format? also try without the first = sign

=Only({$<Index_YearWeek={"$(=max(Index_YearWeek))"}>}Index_CFI)

Re: Set Analysis

chriys1337 — Thu, 02 Feb 2017 09:53:04 GMT

Thanks so much for your quick reply. This worked again, now I am just asking myself why it worked for the first expression with = and the second now just without... 🙂

Thx Sunny!

Re: Set Analysis

sunny_talwar — Thu, 02 Feb 2017 10:00:45 GMT

I am not sure what the difference is, but if you look at my previous response, I did suggest a similar (without the first = sign) in my previous response also.