Distinct numbering in chart expression

Wed, 12 Oct 2011 18:07:46 GMT

Hi all,

I’m struggling with something in QlikView and I hoped you could help me.

I’m trying to ‘AutoGenerate’ distinct values/numbers not during the load script, but in a chart expression (the reason is that the numbering depends on the currently shown items, based on user selection, and thus cannot be calculated during the load script).

For example:

I load a table that looks like this:

USA USD

Australia AUD

France EUR

Spain EUR

Japan JPY

Italy EUR

and the chart (say, straight table) should look like:

USD 1

EUR 2

AUD 3

USD 1

AUD 3

EUR 2

each value that is shown based on the current selection gets a unique number.

How can I do that in the chart expression? Using the Rank() function got me close but not quite there.

Thank you!

Re: Distinct numbering in chart expression

swuehl — Wed, 12 Oct 2011 19:38:09 GMT

Hi itaymaor82,

just for interest, what is your expression approach using Rank()? That was also one of my first ideas..

Try this:

=aggr(NODISTINCT RowNo(),CURR)

if CURR is the fieldname of your currencies.

Hope this helps,

Stefan

Distinct numbering in chart expression

Fri, 14 Oct 2011 19:43:49 GMT

It works! Thanks so much!

topic Distinct numbering in chart expression in QlikView

Distinct numbering in chart expression

Re: Distinct numbering in chart expression

Distinct numbering in chart expression