topic Re: Subfield for Movie Genres in QlikView

Subfield for Movie Genres

Jojo17 — Wed, 25 Nov 2020 16:16:04 GMT

Hi there,

my data looks as follows:

(and the list goes on, with each movie having various numbers of genres)

Am looking to use the sub field function to do an assessment on the Genres, would need some help here, thank you! 🙂

Re: Subfield for Movie Genres

Anil_Babu_Samineni — Thu, 27 Dec 2018 07:45:35 GMT

What you want from that data? May be

Subfield(FieldName, '|') as Output

Re: Subfield for Movie Genres

Jojo17 — Thu, 27 Dec 2018 07:55:45 GMT

One movie is tagged to a few genres and I would like to have a chart which shows the various genres and the number of movies per genre.

Re: Subfield for Movie Genres

Anil_Babu_Samineni — Thu, 27 Dec 2018 08:14:39 GMT

Your data structure not understand to me. Can you create proper data and expected result

Re: Subfield for Movie Genres

uacg0009 — Thu, 27 Dec 2018 08:21:09 GMT

Hi Jodi,
I assume that you have "movie" and "genre" in your table.
And firstly you need to use subfield() in your srcipt,like:
load movie,
subfield(genre,'|') as genre
resident yourtable;
Then in the front-end, you can create a straight table:
dimension: genre
expression: count(distinct movie)
please try.
Aiolos Zhao

Re: Subfield for Movie Genres

Jojo17 — Fri, 28 Dec 2018 07:44:01 GMT

My data file looks as follows:

I would like to create a chart which shows which genre is most popular.

I tried the following:

LOAD MovieID,
Title,
Genres

Subfield(Genres, '|') as Genres

But it did not return a result and was an error.

Re: Subfield for Movie Genres

Anil_Babu_Samineni — Fri, 28 Dec 2018 07:49:27 GMT

Error - Because, You are using same field with in the Single Load. Perhaps this?

LOAD MovieID,
Title,
Subfield(Genres, '|') as Genres

From Sample;

Re: Subfield for Movie Genres

Jojo17 — Fri, 28 Dec 2018 07:57:01 GMT

I see, thanks! Managed to get it to work now 🙂