topic Set analysis on key field in QlikView

Set analysis on key field

Fri, 17 Feb 2017 09:14:16 GMT

Hi All,

I have large fact table which contains Date field which actually not a primary key. I have linked this Fact table on Date field with calendar. In my charts I have used set analysis like Date ={">=$(vMin)<=$(Max)"} I have heard that set analysis on linked field is not advisable. Will it cause performance issue?

swuehl‌ gwassenaar‌ stalwar1‌

Re: Set analysis on key field

sdmech81 — Fri, 17 Feb 2017 09:38:51 GMT

Hi,

U have master calendar date associated with fact,so to do that what u did is correct only.

It wont cause performance issue I guess..

Sachin

Re: Set analysis on key field

CELAMBARASAN — Fri, 17 Feb 2017 09:42:36 GMT

Hi,

Set analysis won't make any performance issue, you can use it all the places and it is recommended.

Calendar table can be linked with Date field, that won't make any issues.

Re: Set analysis on key field

sunny_talwar — Fri, 17 Feb 2017 09:47:44 GMT

Where have you heard this? You might be confusing this with something else, because I have also not heard of any set analysis issues with key field (if that is what you mean when you say linked field)

Re: Set analysis on key field

Kushal_Chawda — Fri, 17 Feb 2017 10:17:10 GMT

I don't think it will be a issue. I think you are mixing other stuff with set analysis. I also haven't heard anywhere. If you can share the link where you read this, it will be helpful.