Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Set analysis & Calculated dimensions

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

1 Solution

Accepted Solutions
sunny_talwar

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)

View solution in original post

2 Replies
sunny_talwar

Try this:

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

sunny_talwar

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)