topic Re: cross table in QlikView

cross table

Fri, 29 Mar 2013 06:18:18 GMT

Hi,
i m making a dashboard from hive table.
i need to make a cross table.
i have tried the following command

CrossTable(sentiment_category, sentiment_score )
LOAD Key,
actor,
bond_girl,
car,
director,
Resident Main;

but it does not work.

kindly help

Regards teja.

Re: cross table

Fri, 29 Mar 2013 06:32:00 GMT

Hi,

Maybe you can use

CrossTable(sentiment_category, sentiment_score,2,4 )
LOAD Key,
actor,
bond_girl,
car,
director,
Resident Main;

Regards,

Amay

Re: cross table

Fri, 29 Mar 2013 06:32:08 GMT

Hello Teja,

Please post your requirement here. how you need the output.

Thanks,

Sampath

Re: cross table

Fri, 29 Mar 2013 06:39:37 GMT

Hi sampath,

Am having a table which contains 10 different columns,

i need those columns to be appeared as rows.

Regards

teja.

Re: cross table

Fri, 29 Mar 2013 06:44:16 GMT

try this

crosstable(category,value,20)

load

Sr.No

Created_at

user:id_str,

user:follower_count,

user:favourites_count,

user:created_at,

user:screen_name,

user:name,

user:lang,

user:listed_count,

user:statuses_count,

user:geo_enabled,

user:location,

user:friends_count,

user:time_zone,

user:utc_offset,

retweet_count,

retweeted_status:retweet_count,

retweeted_status:id_str,

retweeted_status:user:id_str,

Actor,

Bond_Girl,

Car,

Director,

James_Bond,

Music,

Production_House,

Trailer Villian Writer

from table;

Re: cross table

nizamsha — Fri, 29 Mar 2013 06:45:08 GMT

CrossTable(sentiment_category, sentiment_score,2 )

LOAD Key,

actor,

bond_girl,

car,

director,

Resident Main;

Try this one

Re: cross table

Fri, 29 Mar 2013 06:56:00 GMT

Check the example attached

Re: cross table

Fri, 29 Mar 2013 07:09:52 GMT

hi,

Its not working

Regards

Tejavardhan.

Re: cross table

Fri, 29 Mar 2013 07:13:24 GMT

hi sampath,

Am using qlikview personnel edition i cant open please can u help me in other way

Regards,

Tejavardhan

Re: cross table

Fri, 29 Mar 2013 07:15:28 GMT

Hi,

this code is working fine when am using excel sheet but i need data from hive table when am trying the above query its not working.

regards,

Tejavardhan

Re: cross table

Fri, 29 Mar 2013 07:17:29 GMT

Hi Teja,

Can you upload a sample qvw.

Re: cross table

Fri, 29 Mar 2013 07:19:06 GMT

Hi,

Can you provide sample input and sample output for the same?

It will help to provide you exact solution.

Regards,

Amay

Re: cross table

Fri, 29 Mar 2013 07:28:15 GMT

hi,

please find the attachment for sample data.

Regards,

Teja

Re: cross table

Fri, 29 Mar 2013 07:35:13 GMT

And how would be output of this?

Regards,

Amay

Re: cross table

Fri, 29 Mar 2013 08:24:28 GMT

hi,

My output should contain a list box in which all those category names like actor,joker,villian should appear together.

please find the attachment.

Regards

teja.

Re: cross table

Fri, 29 Mar 2013 08:53:32 GMT

Hi,

Maybe you use this

Crosstable(Category,Score,21)

LOAD

from test.xls;

I didnt test this.

Regards,

Amay

Re: cross table

Fri, 29 Mar 2013 09:19:06 GMT

use the inline load

category as field and

give actor,car,director,... as field values

here we give fileds as category field values

Re: cross table

Fri, 29 Mar 2013 11:36:11 GMT

Hi,

Its working well but our requirement is to connect that category table to remaining other tables through key for that we r using cross table. If u know any means by which we can connect the inline table with other tables through a key it would be helpful.

Regards,

Tejavardhan.

Re: cross table

Mon, 01 Apr 2013 07:44:06 GMT

Teja,

Attach a sample document with the inline data.

Thanks,

Sampath

Re: cross table

Mon, 01 Apr 2013 12:12:18 GMT

hi sampath,

In the above replies i have attached the excel file which contains the data loaded in hive

Regards,

Tejavardhan