topic Re: Count in QlikView

Count

Mon, 07 Oct 2013 22:03:33 GMT

Hi there,

please see attachment

Re: Count

manas_bn — Mon, 07 Oct 2013 23:05:54 GMT

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

Re: Count

Mon, 07 Oct 2013 23:25:14 GMT

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

Re: Count

swuehl — Mon, 07 Oct 2013 23:25:57 GMT

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.

Re: Count

Tue, 08 Oct 2013 07:38:26 GMT

Hi there,

I have included in the attachment the dimension and expressions.

Hope it makes sense.

Kaashief