topic Re: crosstables and graphics in QlikView

crosstables and graphics

Thu, 18 Oct 2012 10:59:05 GMT

Hello!

I have a crosstable with this aspect (more or less)

Country August September

Spain 23 14

Germany 48 98

England 27 27

Italy 87 14

France 21 74

I need to represent it in a bars graph, with a expresion corresponding to August and other expresion whit September. The dimensions must be the countries.

How can I do this???

Regards.

Re: crosstables and graphics

Thu, 18 Oct 2012 11:23:44 GMT

Hi,

You just need to make a graph with in the dimenseions 'countries' and in the expressions the two columns.

What is exactly the problem?

Re: crosstables and graphics

Thu, 18 Oct 2012 11:27:30 GMT

Hi.

The problem is that I don´t know what expresions to use to select only the values corresponding to August and the values only corresponding to September. I´ve tried if(month='August',Data), but it doesn´t work. It works only when i select the month in a list, but I need that it shows the graph together without selecting anything.

Thanks.

Re: crosstables and graphics

Thu, 18 Oct 2012 11:33:07 GMT

You only have to add the two columns in the expressions, see image:

Re: crosstables and graphics

Thu, 18 Oct 2012 11:36:11 GMT

Hi,

Please find the attachment.

Hope this one helps you.

Regards,

Kabilan K.

Re: crosstables and graphics

Thu, 18 Oct 2012 11:39:11 GMT

OK, I´ve made it, but without loading it as a crosstable.

Thanks for all, and sorry for this stupid question

Re: crosstables and graphics

Thu, 18 Oct 2012 11:48:43 GMT

I think you have to reorder your input, e.g. like this:

LOAD * INLINE [
    Country, Data, Month
    Spain, 23, August
    Germany, 48, August
    England, 27, August
    Italy, 87, August
    France, 21, August
    Spain, 14, September
    Germany, 98, September
    England, 27, September
    Italy, 14, September
    France, 74, September
];

In the graph enter as dimension Country and Month.

Re: crosstables and graphics

Thu, 18 Oct 2012 19:46:38 GMT

I forgot the reason why i´ve loaded it as a crosstable. The problem is that the file will grow up. New months will be added, and the idea is that only reloading the excel file, the graph will be autogererate by itself, each month in a new group of columns. I don´t know if it is possible to do.