topic Set analysis & Calculated dimensions in QlikView

Set analysis & Calculated dimensions

Tue, 14 Jun 2016 10:22:19 GMT

Hi all,

in a grid chart, I've got calculated dimensions:

- aggr(sum(mysales),account.code)

- aggr(sum(mysales),account.code) / aggr(sum(allsales),account.code)

My expression is simply "account.code".

This works fine for me when no selection is made; the problem comes when an account code is selected: all excluded accounts disappear. My objective is to use a kind of a set analysis maybe to keep all accounts (other solutions are welcome of course).

Thanks in advance for your help,

Marwen

Re: Set analysis & Calculated dimensions

sunny_talwar — Tue, 14 Jun 2016 10:34:30 GMT

Try this:

Only({<account.code>} account.code)

Re: Set analysis & Calculated dimensions

sunny_talwar — Tue, 14 Jun 2016 10:35:11 GMT

You might also need the same thing in your dimension:

- aggr(sum({<account.code>}mysales),account.code)

- aggr(sum({<account.code>}mysales),account.code) / aggr(sum({<account.code>}allsales),account.code)