topic Re: Set analysis in QlikView

Set analysis

mokitsu61 — Mon, 04 Jun 2018 02:25:29 GMT

Hi,

Avg([<key = {"='>' & Min(key))"}>} 1)

Are anyone able to understand this analysis?

Re: Set analysis

petter — Mon, 04 Jun 2018 04:47:27 GMT

This expression has multiple issues that will prevent it from calculating. Basically it doesn't follow the syntax rules of a set expression.

1) The 5th character is [ and it should be {

2) A search which is attempted by the " inside the { will not work as it uses single quotes and a string concatenation which will not render as any valid search.

3) The search expression ends with two ) and they don't match any corresponding two (.

4) Avg(1) is possibly always 1 so what is the purpose of the set expression at all?

Is this an expression you found in an application made by someone else or did you make it yourself? What is the reasoning behind it?

Re: Set analysis

mokitsu61 — Mon, 04 Jun 2018 05:16:39 GMT

Thank you for your replying.

Original topic is follow.

Filter table box rows by range

I got a advice for it, but I couldn't understand example I got...

Re: Set analysis

petter — Mon, 04 Jun 2018 06:16:14 GMT

In the thread you are referring to the one who gave you the expression said it was a dummy expression. Meaning that it might not make sense and that it is just a placeholder expression. Usually I provide only the number 1 ... a plain single digit of 1 to serve that purpose.

Re: Set analysis

mokitsu61 — Mon, 04 Jun 2018 07:09:11 GMT

Thanks, I'm just starting QV and I was spending 1.5 days for trying understand the example I got...