topic Reporting textual answers in QlikView

Reporting textual answers

Fri, 09 Mar 2012 09:23:19 GMT

Hi there,

I have the following problem:

One of our goals is to produce reports with textuals answers in it with QV.

The problem is, sometimes there are more answers in the listbox than there can viewed on one slide.

The result is that not all answers for a specific questions are not shown on the report slide.

Making the font smaller does not help, the amount of text is still too much.

How could I overcome this?

Is there anyway I could Split up the contect of a listbox on two slides in the report?

And only if the the content of the listbox is too much to be shown in one slide?

I hope I'm making myself clear.

Anyone suggestions or solutions?

Kind regards,Tim Dries

Reporting textual answers

jvitantonio — Fri, 09 Mar 2012 09:27:19 GMT

Hi, why don't you filter your answers? Add a number to each answer, then show the first X number of answers in the list box.

Reporting textual answers

Fri, 09 Mar 2012 09:31:15 GMT

Hi there,

Thanks for your response,

Could you elaborate more about automatically numbering the questions?

Is this possible without showing the actual number in front of the answer?

How would the script for show first x answers look like?

Thanks a lot!

Kind regards,

TimDries

Re: Reporting textual answers

jvitantonio — Fri, 09 Mar 2012 09:37:33 GMT

Check out the solution

Re: Reporting textual answers

Fri, 09 Mar 2012 09:48:05 GMT

Could you paste the script?

I can not open the file!

Thank you very much,

Tim Dries

Re: Reporting textual answers

Anonymous — Fri, 09 Mar 2012 10:03:32 GMT

use this in inline

table1:

LOAD * INLINE [

SampleField

A1,

A2,

A3,

];

load SampleField, RowNo() as RowAnswerNum Resident table1;

Create a listbox and enter the this exprssion in your listbox expression edit module

=if(RowAnswerNum<=2,SampleField)

Regards

Reporting textual answers

jagan — Fri, 09 Mar 2012 10:10:18 GMT

Hi,

Display values in the list box in multiple columns by using

Chart Properties -> Presentation -> "uncheck Single Column" and select "Fixed number of Columns" and give columns number

Hope this helps you.

Regards,

Jagan.

Reporting textual answers

jvitantonio — Fri, 09 Mar 2012 10:30:50 GMT

On your script put this:

table1:

LOAD * INLINE [

Answer

Answer1,

Answer2,

Answer3,

Answer4

Answer5

];

load Answer, RowNo() as Num Resident table1;

---------------

Load the application. Then create a listbox. On your field, select "<Expression>" and put this:

=if(Num<=2,Answer)

This will show you only those ansers with row number <=2.

Now you can apply this to your model.

Reporting textual answers

Fri, 09 Mar 2012 11:45:04 GMT

Hello,

Thank you,

Would I need to use the * sign for loading the answers?

Because it is not possible giving in the answer manually..?

Thanks,

Tim

Reporting textual answers

jvitantonio — Fri, 09 Mar 2012 11:50:21 GMT

of course

you first do

LOAD AnswerField FROM yourAnswerTable;

load AnswerField, RowNo() as Num Resident A;

drop table A: