topic Making a pie graph based on information from different column in QlikView

Making a pie graph based on information from different column

Wed, 09 May 2012 10:07:29 GMT

Hi there,

How would I be able to make a pie graph that shows the frequency of the drinks mentioned?

This should be easy I guess, I'm just not familiar with the way the data is stored.

thanks!

its_anandrjs — Wed, 09 May 2012 10:26:24 GMT

Hi,

I suggest if you want to create a pie chart create crosstable of this data and the create a pie chart. In your example

Cola has 3 frequency,

Water has 2 frequency,

Beer has 1 frequency.

Create crosstable like

CrossTable(FV_Cola, Data)

LOAD Id,

FV_Cola,

FV_Water,

FV_Beer

FROM

Source File.

HTH

Reagrds

Anand

Wed, 09 May 2012 10:35:13 GMT

Thanks man!

its_anandrjs — Wed, 09 May 2012 10:50:17 GMT

Hi,

Thanks, If you got correct answer so mark it correct so other can see it.

Regards,

Anand