topic Set Analysis Help in QlikView

Set Analysis Help

mphekin12 — Mon, 19 Jun 2017 14:24:10 GMT

Hello,

I am having a very strange issue with set analysis and wanted to see if anyone else is experiencing the same issues. I have used the following formulas in several dashboard, but for some reason, they don't seem to be working on one I'm currently working on. The only difference is that this new dashboard was created in QlikView 12.1 SR 4.

So here is the issue. I am using variables and set analysis to determine total encounter and split out encounters that are on or off pathway:

When I select false for the pathway flag field, 'on pathway' and '% on pathway' should be zero because I am using the '$' as my set identifier, but as you can see below, that isn't happening:

For some reason, the count for on pathway patients is retaining its value. Has anyone else seen this issue or can anyone recommend a work around? Like I said, I have used these exact variables and formulas in several other dashboards that I have created and have never had this issue before.

Thank you!

Re: Set Analysis Help

avinashelite — Mon, 19 Jun 2017 14:28:33 GMT

1.Is the data and data model association is same in all the dashboard ?

if not then it won't work

2.Check you have migrated all the variables correctly

3.check the data once ? mainly the data links

Re: Set Analysis Help

mphekin12 — Mon, 19 Jun 2017 14:32:37 GMT

Avinash,

Thanks for your reply. All data model associations are correct, the variables were migrated correctly and I have checked the data several times. It just seems like the set identifier is set at '1' at all times, even though I clearly have the '$' in both the formulas.

Re: Set Analysis Help

avinashelite — Mon, 19 Jun 2017 14:36:17 GMT

Could you share the sample files for the same ?

Re: Set Analysis Help

mphekin12 — Mon, 19 Jun 2017 14:37:41 GMT

Avinash, unfortunately I cannot share this data.

Re: Set Analysis Help

mphekin12 — Mon, 19 Jun 2017 15:23:11 GMT

If anyone else is having this issue, I found a work around. It appears that the set analysis statements in this dashboard doesn't like the fact that the PATHWAY_FLAG field is set as DUAL. What I had to do was create a dual field called PATHWAY_FLAG_TF and left the PATHWAY_FLAG field as numeric field. Now everything is working as it should:

I'm still not sure why I needed to do this in this current dashboard. I have used the same base data model and formulas in several previous dashboards. Wonder if it has something to do with QV 12.10 SR4?