topic Re: count in dimension in QlikView

count in dimension

Fri, 15 Apr 2016 06:40:56 GMT

Good Morning,

Does someone of you know, how to Count in a Dimension?

As you can see the first two project_id's have the same postrule_id.

In this case I dont want to see that entry.

I thought of a count-function in the Dimension so that only the project_id's will be shown where at more than one postrule_id is included.

(Null-values should not be shown in the table)

I searched the qlikview-Forum but could not find anything for Dimension (only for calculation).

Does someone of you have an idea?

Chris

Re: count in dimension

Gysbert_Wassenaar — Fri, 15 Apr 2016 06:51:36 GMT

Perhaps a calculated dimension like this will do the trick: =if(aggr(count(distinct accounting),postrule_id,asset_id,project_id,txnper,txnyear)=1, postrule_id)

If not, please post a small qlikview document that demonstrates the problem.

Re: count in dimension

tresB — Fri, 15 Apr 2016 06:56:04 GMT

You could probably use expression something like:

=If( Aggr( Count( Distinct postrule_id) , txnyear, txnper, projectid)>1, projectid)

in place of projectid

and check 'Suppress When value is Null' in the dimension tab.

Re: count in dimension

Fri, 15 Apr 2016 06:56:24 GMT

Hi Gysbert,

my Dimension accounting is calculated:

=(if (asset_status = 'sold', postrule_id&'.'&kst_id&'.'&project_id&' (H) ', postrule_id&'.'&kst_id&'.'&project_id&' (S) '))

Do you think it is possible to say, that the line should only be shown, if the postrule_id is unequal?

Chris