Using a distinct list to generate a multi line chart?

Tue, 27 May 2014 13:11:46 GMT

I've done some searching but unfortunately I don't think I know the lingo associated with Qlikview well enough to find what I'm looking for on my own.

I have a table. This table contains a date and a "keyword". There are 10 unique keywords. There are hundreds of dates with numerous reoccurrences of each keyword. For instance:

date, keyword

2014-05-27, apple

2014-05-27, banana

2014-05-27, apple

2014-05-27, orange

2014-05-27, mango

2014-05-26, mango

2014-05-26, apple

2014-05-26, etc

This goes on and on.

I'm trying to create a line chart with 10 lines, each representing the frequency of the keyword across the date range in the table.

I know I can create each of these lines using something like this:

=count ( {$<keyword={'apple')>} keyword )
=count ( {$<keyword={'banana')>} keyword )

Each of these expressions equals one line on the chart.

However, I don't really want to have to manually define each of these keywords every time I get a new set of results to analyse which could contain completely different keywords..

Is there a way to generate all 10 lines using one expression? Sort of like a "For loop" in Python maybe?

Much obliged to anyone who can offer some guidance.

Thanks!

Re: Using a distinct list to generate a multi line chart?

Anonymous — Tue, 27 May 2014 13:29:40 GMT

Just use this field (keyword) as another dimension.

Re: Using a distinct list to generate a multi line chart?

Tue, 27 May 2014 13:37:13 GMT

Ahh brilliant, so add the field "keyword" to the Used Dimensions pane, then add a new expression that's "=count(keyword)"?

I tried that, It looks pretty good to me.

I'm still trying to wrap my head around things.

Thanks so much Michael.

topic Using a distinct list to generate a multi line chart? in QlikView

Using a distinct list to generate a multi line chart?

Re: Using a distinct list to generate a multi line chart?

Re: Using a distinct list to generate a multi line chart?