Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
Is it possible to show total row count of a table outside of that table?
If yes, how can I do that?
I want to show total number of row count in a text box. Can someone write the formula for that?
Help will be highly appreciated.
Thanks,
TA
you can still create copy of that table and remove dimension
TA
You need an Aggr() expresssion in your text box in the form:
=Sum(Aggr( <your table expression> , <table dimension 1>, <table dimension 2>, ...))
For example
=Sum(Aggr(Sum(Amount), Region, Month))
You can format the result with the Num() function, for example:
=Num(Sum(Aggr(Sum(Amount), Region, Month)), '# ##0', ,., ' ')
Hope that helps
Jonathan
It is helpful. But why cant I use NumericCount/TextcCount of a field to find the total number or recrods?
Thanks,
Like Jonathan says...
Count of chart rows depends on the dimension You use in that table
So if you want to calculate row count outside the table you need to use function aggr with the same dimension as in the table
Can I use more than one dimension to get the total number of records outside the table?
I have used count, numeric count etc but no luck so far.
...read Jonathan message again...
carefully:)
or send us sample qvw file
Hi Pari Pari,
First of all your name is gerat....its secret for my family.
Second of all...
I read Jonathan message, but could not follow it. Here are my dimensions and expression which I want to use in order to get the total number or records for.
and here are my expressions (I could not get the right result becasue of expressions may be, because I am using an if condition in my expression)
(Sum ([ANON PV 4WKS])>(vANONPVLast4WeeksHL2)And
(Sum ([ANON SM HPW 1WK])>(vAONONHPWLastWeekHL2) And
(Sum ([ANON SM HPW 4WKS])>(vAONONHPWLast4WeeksHL2))))
,Sum ([ANON PV 1WK]))
(Sum ([ANON PV 4WKS])>(vANONPVLast4WeeksHL2)And
(Sum ([ANON SM HPW 1WK])>(vAONONHPWLastWeekHL2) And
(Sum ([ANON SM HPW 4WKS])>(vAONONHPWLast4WeeksHL2))))
,Sum ([ANON PV 4WKS]))
(Sum ([ANON PV 4WKS])>(vANONPVLast4WeeksHL2)And
(Sum ([ANON SM HPW 1WK])>(vAONONHPWLastWeekHL2) And
(Sum ([ANON SM HPW 4WKS])>(vAONONHPWLast4WeeksHL2))))
,Sum ([ANON SM HPW 1WK]))
(Sum ([ANON PV 4WKS])>(vANONPVLast4WeeksHL2)And
(Sum ([ANON SM HPW 1WK])>(vAONONHPWLastWeekHL2) And
(Sum ([ANON SM HPW 4WKS])>(vAONONHPWLast4WeeksHL2))))
,Sum ([ANON SM HPW 4WKS]))
Can you write a Aggr function statement which can give me the total number of records for these dimensions and experssion?
Thanks,
TA
Hi,
If there are more than one expressions in a table, then how can I use them to find out the total number or records?
Do I have to use all of them or I can just one of them along with dimensions?
Can I just use one dimension e.g KEY instead of all dimensions?
Or I have attahced a qvw which has two types of expression one with IF logic and one with SET.
I want to show total number or records for both of them seperately. For IF logic expression is showing the correct result but SET not. Can you please update this QVW with show the exact number of records for both types of expressions?
Thanks,
TA
Hi,
Did you figure out a way to get the physical number of rows? I am trying to achieve the same thing and none of the recommendations really helped. Appreciate if you can help me if you figured out a way.
Thanks