Set analysis issue

[chiragngohel]

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

[SunilChauhan]

can you share the formula ?

[chiragngohel]

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

[chiragngohel]

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

[SunilChauhan]

it look like correct but you can try below code

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

or

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

[chiragngohel]

not working, mate!

come up as expression error!

[chiragngohel]

not working, mate!

come up as expression error!

[SunilChauhan]

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

or

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

[chiragngohel]

No luck yet.