Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

chiragngohel
New Contributor II

Set analysis issue

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

8 Replies
chauhans85
Esteemed Contributor

Set analysis issue

can you share the formula ?

chiragngohel
New Contributor II

Set analysis issue

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

chiragngohel
New Contributor II

Re: Set analysis issue

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

chauhans85
Esteemed Contributor

Set analysis issue

it look like correct but you can try below code

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

or

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


chiragngohel
New Contributor II

Set analysis issue

not working, mate!

come up as expression error!

chiragngohel
New Contributor II

Re: Set analysis issue

not working, mate!

come up as expression error!

chauhans85
Esteemed Contributor

Set analysis issue

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

or

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


chiragngohel
New Contributor II

Re: Set analysis issue

No luck yet.

Community Browser