topic Re: Listbox in QlikView

Listbox

deepakqlikview_123 — Thu, 03 Apr 2014 05:30:15 GMT

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

Re: Listbox

its_anandrjs — Thu, 03 Apr 2014 05:41:17 GMT

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

Re: Listbox

muniyandi — Thu, 03 Apr 2014 05:42:58 GMT

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.

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

Regards,

Muni

Re: Listbox

its_anandrjs — Thu, 03 Apr 2014 05:46:57 GMT

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

Re: Listbox

deepakqlikview_123 — Thu, 03 Apr 2014 06:04:29 GMT

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

Re: Listbox

MK_QSL — Thu, 03 Apr 2014 06:07:06 GMT

Check this ...

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

Re: Listbox

its_anandrjs — Thu, 03 Apr 2014 06:08:26 GMT

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

Regards

Re: Listbox

sunilkumarqv — Thu, 03 Apr 2014 06:11:00 GMT

find the attached hope these helps you

Re: Listbox

its_anandrjs — Thu, 03 Apr 2014 06:13:10 GMT

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