Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Count

Hi there,

please see attachment

count.jpg

4 Replies
manas_bn
Creator
Creator

Could you please give a little more detail, especially what you are using as the expression to come up with the column "Num"?

Not applicable
Author

Hi Kaashief,

Could it be that you have data in Uniset1 that is not allocated to any server?

If you take out the 'Suppress when value is null' on Table Proprieties>Dimensions you should get clear picture, if that is the case.

Hope this helps.

Kind regards,

Nuno

swuehl
MVP
MVP

Are you using total mode 'sum of rows' in your straight table, for the expression in question?

Then try maybe something like

=sum( aggr( YourExpressionForNumColumn, ServerClassification, Server))

replace YourExpressionForNumColumn with the expression used (like sum(Value) or count(Incidents) ) and check if ServerClassification and Server matches your upper chart dimensions.

Not applicable
Author

Hi there,

I have included in the attachment the dimension and expressions.

Hope it makes sense.

KaashiefCount2.png