topic Re: Set analysis on integer ranges not working in QlikView

Set analysis on integer ranges not working

koscumbs — Sat, 16 Nov 2024 19:37:08 GMT

Good afternoon (or morning, or whenever you read this),

I'm having inconsistent performance from an expression using set analysis. When one of our analysts writes an expression using set analysis:

=num(count({<TIMEFRAME_1_12_MONTH_VISIT_FLAG = {'1'},FIRST_VISIT_1_12_FLAG = {1},DAYS_RUNOUT = {'>180'},MORTALITY_INTERVAL = {'<180'}>} distinct IDENTIFIER)
/count({<TIMEFRAME_1_12_MONTH_VISIT_FLAG = {'1'},FIRST_VISIT_1_12_FLAG = {1},DAYS_RUNOUT = {'>180'}>} distinct IDENTIFIER),'###,###.0%')

they get a null result (" - ") in any of their sheet objects (charts, list boxes, etc). We found that, oddly, the same exact expression works fine on my machine.

We systematically removed pieces from the set analysis until we found where the problem lay: the DAYS_RUNOUT = {'>180'},MORTALITY_INTERVAL = {'<180'} pieces -- for some reason, this works just fine on my computer, but does not function on our other analysts machines.

Any ideas? It feels like this is a user preferences issue or versioning issue, but it's still very odd.

Any help is appreciated, and thanks in advance.

Re: Set analysis on integer ranges not working

Vegar — Thu, 21 Nov 2019 22:40:08 GMT

There where some issues regarding set analysis and quotation marks during a couple of releases last year. The result was change in the intepretion of the set between versions.

Try this

DAYS_RUNOUT = {">180"},MORTALITY_INTERVAL = {">180"}

Re: Set analysis on integer ranges not working

Lisa_P — Thu, 21 Nov 2019 22:41:21 GMT

Use double quotes for any searches eg

DAYS_RUNOUT = {">180"},MORTALITY_INTERVAL = {"<180"}

Re: Set analysis on integer ranges not working

koscumbs — Thu, 21 Nov 2019 22:42:46 GMT

So you think maybe mine works because I have an older version of Qlik?

I will test with them tomorrow and confirm if that works.

Thank you!

Re: Set analysis on integer ranges not working

koscumbs — Fri, 22 Nov 2019 15:03:13 GMT

Works perfectly! How bizarre, but thank you very much for the help!