Customizable Straight Table

[Jennell_Yorkman]

In many of the demos that I have done, I have added a customizable straight table or ad-hoc report where the user can select the dimensions and measures that should appear in the chart.  This is often helpful and can replace multiple detailed straight tables in an application.  Creating the customizable chart involves simply loading the dimensions and measures that the users can pick from and then adding a straight table with conditional dimensions and expressions.

In the Call Detail Record Analysis demo a customized report was added to the application.  This is how the ad-hoc report looks with some dimensions and metrics selected.

The steps taken to build this report were:

• Load dimensions and metrics that should appear in the list box for the user to choose from.  In this example, this was done by adding two inline tables with the script below.

• Then list boxes for _dimension and _metrics were added to the report sheet with the LED Check boxes selection style.

    

• Next a straight table is added to the sheet with the following conditional calculation:

    

        The chart will be displayed if at least 1 dimension and 1 metric are selected from the list boxes.

• Next the dimensions were added to the table.  Each dimension in the list box was added to the chart with a conditional expression so that the dimension is only displayed if it is selected from the Dimensions list box.

    

• The same was done for each measure listed.

    

In five easy steps, a customizable straight table or report can be added to your QlikView application providing users the ability to display a report with the data they want to see at the time.  This gives the user more flexibility and reduced the need to add detailed straight table charts to the sheets in the application.

You can read more about this topic in my Technical Brief which has more detailed step-by-step instructions.  Have fun!

Thanks,

JMC

[amien]

You can put your straight table in a container object (grid,1 x 1)

[mayankraoka]

Thanks Amien for quick reply.

But  in this I am not getting any scroll bar in table also.I need to see many columns so it should allow to scroll on table.

Regards,

Mayank

[mayankraoka]

I mean to say Horizontal scroll to read the extended columns

[mayankraoka]

How Can I get horizontal scroll bar in the table if I follow ur approach?

Regards,

Mayank

[varunreddy]

Hi Jennell,

I am creating dynamic report using a bar chart. User needs to select only two dimensions and if he select third dimension, then report will show error message.

Now the issue is, the dimensions are taking in the way I added the dimensions not in the way I want

For example,

I have added in this format:

1. Date

2. Status

3. Severity.

If I select Status and severity as dimensions and if I stack it, data is getting stacked by severity. What if I want it to be stacked by Status?

Is there a possiblity to solve this issue?

Thanks in advcance!

Cheers

[ishanbhatt]

Hi Jannell,

We used this approach and it's work perfectly.

Thanks.

[beck_bakytbek]

Very helpful and informative,

and especially is very simple to understand

[beck_bakytbek]

Super,

thanks a lot for this great topic

[vengadeshpalani]

Hi jmc

Pls Explain why the chart was changed based on enable and disable the second Dropped % expression

[Jennell_Yorkman]

Hi Vengadesh,

The third expression controls the size of the bubbles.  If it is disabled, the bubbles will all be the same size.

Hope this helps.

Kind Regards,

Jennell