Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Customers, Partners & Luminaries only: You're invited to a Data Analytics Roadmap session. Read More
Showing results for 
Search instead for 
Did you mean: 
Not applicable

count in dimension

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?


3 Replies
MVP & Luminary
MVP & Luminary

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.

talk is cheap, supply exceeds demand

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.

Not applicable

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?