topic Re: List Box Blank Space Issue in QlikView

List Box Blank Space Issue

Tue, 24 Jan 2012 10:29:12 GMT

Hi,

Is there any object other than list box to display the values by on selections, because in my report i want to update that Hierarchy based on selections. Here am using listboxes for displaying the data but in list box am getting blank spaces before and after the values please see the attached screen, how to fit/adjust list box based on data or do we have any other object for this and how to avoid these blank spaces?

Regards,

Anil

List Box Blank Space Issue

swuehl — Tue, 24 Jan 2012 10:45:06 GMT

Have you tried using a tablebox?

List Box Blank Space Issue

Tue, 24 Jan 2012 11:00:19 GMT

thnx for your replay Swuehl, I have tried it but i have a calculation condition to display the data my condition is not working in table box, how to use calculation condition in table box

List Box Blank Space Issue

swuehl — Tue, 24 Jan 2012 11:04:45 GMT

You can't use a calculation condition in a table box.

You can, however, use a straight table chart with a calculated dimension and as expression a constant

and hide expression in presentation tab.

List Box Blank Space Issue

Tue, 24 Jan 2012 12:15:00 GMT

Yes Swuehl this is correct answer thanx for your suggestion.......

Re: List Box Blank Space Issue

Miguel_Angel_Baeyens — Tue, 24 Jan 2012 12:20:44 GMT

Hi,

I may be missing something, but the table box is actually able to use a calculation condition. Check the file attached using a variable and a button to show / hide the table box.

Hope that makes sense.

Miguel

List Box Blank Space Issue

swuehl — Tue, 24 Jan 2012 12:29:46 GMT

You are right, Miguel, a table box could use a calculation condition.

I was assuming and thinking of a calculated dimension / field expression (in a list box), but calculation condition is indeed something different and I should try not mixing up wording.

Regards,

Stefan

List Box Blank Space Issue

Tue, 24 Jan 2012 13:14:36 GMT

Yes its good thnx MIguel,Swuehl,, but we can't use field expression in table box am i correct? if wrong please correct me

Re: List Box Blank Space Issue

Miguel_Angel_Baeyens — Tue, 24 Jan 2012 14:39:56 GMT

Anil,

You are right. Table boxes don't allow to use expression to create calculated dimensions. Anyway, bearing in mind the poor performance that have the calculated dimensions, I'd rather create the fields as required in the script, doing all necessary stuff to get the values as expected, and use them in either listboxes or table boxes, not to mention charts.

Hope that makes sense.

Miguel