topic Re: DYNAMIC METRICS in QlikView

DYNAMIC METRICS

Manoj_my — Fri, 15 Nov 2024 23:12:52 GMT

Hello Experts –

I am trying to create a dashboard as shown in the picture below and request your guidance/assistance

User can select any one department from the drop down – Ex : Sales
The charts must update and show the Metrics related to SALES
Likewise if HR is selected the graphs must update to show HR related metrics
We are ideally looking to have the metrics and their calculations in a table so that any changes can be easily maintained
Am fairly aware of an inline concept but that only works if you have a single metric for a Dept and not sure how to modify if a Dept has multiple metrics

Any guidance or help is much appreciated

Thanks

Re: DYNAMIC METRICS

edwin — Tue, 02 Feb 2021 19:20:07 GMT

what you are looking for is a trellis chart

Assuming you have Value and Target as separate fields and you have a Metric Field:

create a bar chart with sum(actual) and sum(budget) as separate expressions

enable trellis

add Metric (assumed as a separate field) as dimension:

Re: DYNAMIC METRICS

Manoj_my — Wed, 03 Feb 2021 07:55:28 GMT

Hello Edwin - Thank you for the thoughts ...will explore Trellis

Trellis may not work out as we do not have METRIC as part of the data model / data set and as such data needs to be aggregated/ calculated to derive the metrics

Re: DYNAMIC METRICS

edwin — Wed, 03 Feb 2021 13:46:57 GMT

there are multiple ways of doing this and each with its own level of elegance.

one is to create multiple charts and enable disable each based on the dimension (dept)
other is as i said using trellis - but trellis is dependent on the existence of a dimension that is linked to your metrics. you can of course create that dimension and there are multiple ways of doing that too, i prefer to create the metric list in my load script, others can move that to the chart itself using valuelists.

take a look at this where i created a "metric" dimension. then in my expression i specified the calculation per "metric" dimension which i think applies to your case. you can also create a table where the metric is associated with a variable name and the calculation is defined in the variable - that would be cleaner but will take more effort

Re: DYNAMIC METRICS

Manoj_my — Thu, 04 Feb 2021 14:22:24 GMT

This is great am certainly walking away with the Trellis concept you shared

For my current task ..I explored the attached solution - Please let me know your thoughts feedback too

I have a config table as attached with the expression used in the charts which has the Metrics formula and the DEPT links back to my main data set

If Sales has 5 charts i would just have 5 expression and simply increment from 1 to 5 in the expression and so on for each DEPT and still use conditional hide of individual charts

With this set up i can easily change which chart should hold what metric and so on

Again many thanks for the guidance and ideas shared - really valuable and informative

Thank you

Manoj