Listbox

[deepakqlikview_123]

Hi All,

Please find attached screenshot.

can you please tell me how to get list of dimensions for selections in pivot table  as per row and column wise dynamically by using list boxes.

How to create variable for the same.

Thanks

[its_anandrjs]

This are the adhoc reports for this refer the qlikview sample applications (whats new in qlikview11) there is a Reports sheet.

For dimension you have to create a inline table then you can get dimension tables and use it in pivot table.

Hope this helps

[muniyandi]

Hi,

add all the dimension and expression and then enable / disable to dimension and expression based on your list box selection.

ex:

=SubStringCount(Concat(_dimension, '|'), 'Year')

_dimension Is listbox fieldname. Year is listbox value.

Or

verify once in Whats new in Qlikview 11.QVW --> Reports Tab.

Regards,

Muni

[its_anandrjs]

Like adhoc dimension list with inline table

AdhocDimensions:

LOAD * INLINE [_dimension

Customer

Region

Country

City

Year

Month

Quarter

Item Number

Product Group

Product Line

Product Sub Group

Product Type

Manager

Sales Rep Name

Address Number

Invoice Date

Invoice Number

Item Desc

Item Number

Order Number

Promised Delivery Date

];

and in any straight table or pivot table you have to use like

=SubStringCount(Concat(_metricsNo, '|'), 1)

Hope this helps

[deepakqlikview_123]

Hello anand,

Thanks for reply

Is adhoc dimension is something same as creating artificial dimension.

Which fields can we take while creating ad hoc dim,moreover what are benefits by using it.

Thanks

[MK_QSL · Accepted solution]

Check this ...

http://community.qlik.com/blogs/qlikviewdesignblog/2014/01/31/customizable-straight-table

[its_anandrjs]

A dimension fields that are available in your data model is preferred you can give another name also.

Regards

[sunilkumarqv]

find the attached hope these helps you

[its_anandrjs]

You can set tag for the different dimension in script and maintain a expression table also

MetricsOptions:

LOAD * INLINE [_metricsNo, _metrics

1, Sales,

2, Qty,

3, Margin

4, Margin%

];

MetricPickOne:

LOAD DISTINCT

  _metrics as _metricPickOne

RESIDENT MetricsOptions;

TAG FIELDS Manager SalesRep, $Dimension;

TAG FIELDS [Sales Rep Name] SalesRep, $Dimension;

TAG FIELDS Customer Customer, $Dimension;

TAG FIELDS Region Customer, $Dimension;

TAG FIELDS Country Customer, $Dimension;

TAG FIELDS City Customer, $Dimension;

TAG FIELDS Year Time, $Dimension;

TAG FIELDS Month Time, $Dimension;

TAG FIELDS Quarter Time, $Dimension;

TAG FIELDS [Item Number] Product, $Dimension;

TAG FIELDS [Product Group] Product, $Dimension;

TAG FIELDS [Product Line] Product, $Dimension;

TAG FIELDS [Product Sub Group] Product, $Dimension;

TAG FIELDS [Product Type] Product, $Dimension;

Hope this helps