Number of

[kris_vliegen]

Hi all,

I have a little question. Is there a possibility to count the number of values i a bar-chart?

I have this graph and I would like to see the top(n) in the caption.

Now I work with getselectedcount but it counts only the values of Jul/2014 (set analysis)

Regards,

Kris

[PrashantSangle]

Hi,

Use =count(distinct Kaart)

Regards

[francoiscave]

Hi Kris,

Getselectedcount returns the current number of selected values in a field.

If IncludeExcluded is true the count will include selected values, which are currently excluded by selections in other fields. If false or omitted these values will not be included.

Can you try with Getselectedcount(field, true()) ?

Or use an other Chart Field functions or use count(distinct Kaart) function.

Have fun with QV,

François

[kris_vliegen]

Hi,

I would like to see Top 5 in my caption.

If I use =Getselectedcount(Firmakaart, true())  then I get 0

If I use =count(distinct Firmakaart) I get 0.

The problem is that I have 2 Expressions with set analysis and He give me only the number of the first expression...

Regards,

Kris

[francoiscave]

Kris,

Can you send a sample app.

It will be easier to help you on your chart.

François

[kris_vliegen]

Here is my app.

I would like to see "Top 5" in the caption

Regards,

Kris

[francoiscave]

Kris,

I have "Top 5" in the caption...

I've used this expression:

='Top ' & Count(Distinct Firmakaart)& ' ' & Only({<Index={163}>} Data) & ' (' & Only({<Index={37}>} Data)  & ')'

='Top ' & GetPossibleCount(Firmakaart)& ' ' & Only({<Index={163}>} Data) & ' (' & Only({<Index={37}>} Data)  & ')'

It's what do you expect ?

François

[kris_vliegen]

Yes, but If you select _Calyear = 2014 and _CalMonth = jul

Then you have 4 cards fur jul and 4 for jun.

And in total you have 5 Cards in the graph.