topic Re: Number of in QlikView

Number of

kris_vliegen — Fri, 23 Jan 2015 09:00:20 GMT

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

Re: Number of

PrashantSangle — Fri, 23 Jan 2015 09:15:31 GMT

Hi,

Use =count(distinct Kaart)

Regards

Re: Number of

francoiscave — Fri, 23 Jan 2015 09:23:16 GMT

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

Re: Number of

kris_vliegen — Fri, 23 Jan 2015 09:29:50 GMT

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

Re: Number of

francoiscave — Fri, 23 Jan 2015 09:32:23 GMT

Kris,

Can you send a sample app.

It will be easier to help you on your chart.

François

Re: Number of

kris_vliegen — Fri, 23 Jan 2015 10:07:53 GMT

Here is my app.

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

Regards,

Kris

Re: Number of

francoiscave — Fri, 23 Jan 2015 10:15:03 GMT

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

Re: Number of

kris_vliegen — Fri, 23 Jan 2015 10:18:10 GMT

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.