topic Re. :Re: Count? in QlikView

Count?

Fri, 14 May 2010 08:48:33 GMT

I've got a table with musician (ID, musician name,...) and table with their albums (ID, album name), so that musician1 have 4 albums, musician2 1 album,...

Now, I want to design a chart, that shows artists name and their number of albums. How can I do that? Thanks!

Count?

Fri, 14 May 2010 09:11:28 GMT

Hi QursV52v,

Load

ID,MusianName from Table1;

Load

ID,AlbumName from Table2;

In chart just put a expression like count(Albumname) with ID or Musianname.

If you have any queries please let me know...

Regards,

Ravi....

Re. :Count?

martin59 — Fri, 14 May 2010 10:04:27 GMT

Hello,

You have to put the Musician Name like dimension.

And your expression must be :

Count(Distinct ID_Album)

Regards,

Martin

Count?

Fri, 14 May 2010 10:05:10 GMT

Where do I write 'Load...'?

'like count(Albumname) with ID' What do You mean with 'ID'?

Re. :Re: Count?

martin59 — Fri, 14 May 2010 10:09:17 GMT

You have to write your script to import data.

Folders --> Edit script.

You have got some assistant on bottom of window.

Martin

Re. :Re: Count?

Fri, 14 May 2010 10:37:04 GMT

I've edited the script as You wrote, but when I press reload it says to me: 'Cannot open file 'C:\Documents and Settings\...' Load ID, MusicianName from tblMusician' and the same for the Album...

Re. :Re: Re. :Re: Count?

martin59 — Fri, 14 May 2010 10:54:21 GMT

What's your file ? xls ? mdb ? txt ?...

Re. :Re: Re. :Re: Count?

Fri, 14 May 2010 10:55:22 GMT

mdb (Access DB)!

Re. :Re: Re. :Re: Count?

Fri, 14 May 2010 12:40:39 GMT

Hi,

If it is a mdb then, You need to create a connection(First DSN) in script then select tables. if you are aware this activities then do, otherwise reply on the same.

Regards,

Ravi...