topic Re: How to convert Excel formula : count to QV? in QlikView

How to convert Excel formula : count to QV?

Mon, 16 Mar 2015 15:59:59 GMT

I want to tell the rows in a table, because I want to make a formula with it.

I want to do this formula: an amout / number of rows.

In Excel you can tell the rows with the formula: count(... : ...)

Thank you.

Re: How to convert Excel formula : count to QV?

robert_mika — Mon, 16 Mar 2015 20:56:11 GMT

Re: How to convert Excel formula : count to QV?

Tue, 17 Mar 2015 07:53:26 GMT

Thanks for you answer.

But how can I hide the columns: NoOfRows() and =sum(Points)/NoOfRows()?

And how can I the answer of =sum(Points)/NoOfRows() put in a separate textbox?

Re: How to convert Excel formula : count to QV?

jonathandienst — Tue, 17 Mar 2015 08:08:54 GMT

Why do you want to add the columns and then hide them? You can use a conditional on the expressions tab, hide column in the presentation tab (straight table), or disable the expression on the expressions tab.

You can't use NoOfRows() in a text box, it is only valid in a chart or table object. The number of rows is determined by the distinct dimension values - in your case

Count(Distinct Face)

will return the same value.

HTH

Jonathan

Re: How to convert Excel formula : count to QV?

Tue, 17 Mar 2015 08:15:43 GMT

That is not what I want, sorry.

Ok, thanks!

Re: How to convert Excel formula : count to QV?

robert_mika — Tue, 17 Mar 2015 08:54:09 GMT

As Jonathan pointed you can use the count in Text box:

Re: How to convert Excel formula : count to QV?

Tue, 17 Mar 2015 09:01:52 GMT

Thanks Robert and Jonathan! You give me the correct formula!