Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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
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
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
A dimension fields that are available in your data model is preferred you can give another name also.
Regards
find the attached hope these helps you
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