topic Set analysis issue in QlikView

Set analysis issue

chiragngohel — Tue, 29 Nov 2011 13:01:16 GMT

Hi To All Qlikview Masters,

I am having very weird kind of issue with Qlikview 9 SR7.

In one of my app, i am using set analysis. Everything working fine in development module but when i switch to access point it bringing up "No Data to display" message despite all data there. I can see all figures in development but not in access point.

If i change formulla using IF, it working fine in access point too.

Has anyone got any clue?

Thanks in advance,

Chirag

Set analysis issue

SunilChauhan — Tue, 29 Nov 2011 14:00:27 GMT

can you share the formula ?

Set analysis issue

chiragngohel — Tue, 29 Nov 2011 14:04:14 GMT

Avg ({$<[Question ID]={'262'}>}score)

Re: Set analysis issue

chiragngohel — Tue, 29 Nov 2011 14:05:25 GMT

Avg ({$<[Question ID]={'262'}>}score)

Set analysis issue

SunilChauhan — Tue, 29 Nov 2011 14:08:01 GMT

it look like correct but you can try below code

Avg ({$<[Question ID]={"262'}>}score)

Avg ({<[Question ID]={"262'}>}score)

Set analysis issue

chiragngohel — Tue, 29 Nov 2011 14:19:30 GMT

not working, mate!

come up as expression error!

Re: Set analysis issue

chiragngohel — Tue, 29 Nov 2011 14:20:10 GMT

not working, mate!

come up as expression error!

Set analysis issue

SunilChauhan — Tue, 29 Nov 2011 14:27:27 GMT

aggr(Avg ({$<[Question ID]={'262'}>}score),[Question ID])

Avg ({1<[Question ID]={'262'}>}score)

Re: Set analysis issue

chiragngohel — Tue, 29 Nov 2011 14:53:47 GMT

No luck yet.