topic Group fields in QlikView

Group fields

sergio — Mon, 22 Mar 2010 14:50:53 GMT

Hi there, i have a little problem with a flat table. I have to load information from a table like this (approximately):

Where quality, language, amability and response are fields with numbers between 0 and 5 that means the punctuation. This table is obtained from audit a call center. I need to group this questions in one field to make a filter for graphs, to select a specific question, and obtain evolutions of the note of the question by dates...but i can't imagine how can i do that. I can´t do a table for each question because the original table has about 25 different questions (25 different fields)...so it means 25 graphs...and i don´t like that...

Sorry for my english and i'll been very grateful for any response.

Thanks!

Group fields

Mon, 22 Mar 2010 15:42:28 GMT

How about adding a field while loading the table that does this


Formulario:
LOAD *,
 quality&language&amability&response AS Answers
FROM ...

It will put all the answers in one field.

Hope I understood your question correctly.

Group fields

Mon, 22 Mar 2010 17:18:42 GMT

You could also look at creating "groups" that are drill downs or cycles in the graph in order to look at different fields within the chart it's self.

Go to dimensions tab in chart properties then at the bottom select groups.

Group fields

sergio — Mon, 22 Mar 2010 19:46:49 GMT

Thanks for your answer Mark, but i need something different. I need to convert the fields in the table Formulario to one unique field...thus i can select a specific question to modify the graph, like to have a field related to another table of questions.

Group fields

sergio — Mon, 22 Mar 2010 19:49:53 GMT

Many thanks Anthony, i have created a ciclic group with the fields of the questions and woks perfect.

Thanks, and greetings!