Charting / Calculations Based on Fields Specified in Lookup Table

Tue, 04 Sep 2012 21:41:53 GMT

Warning! Danger Will Robinson. I am not a developer. I don't even play one on TV.

I am trying to create a simple dashboard for a series of metrics that we look at regarding our storage space.

We have a large number of metrics which are really just simple ratios and rather than clutter the screen with ever permutation, I would rather we have one nicely formated dashboard where the user can select which ratio they are interested in exploring.

To that end, I created a table which includes a list of metrics and the field names that would belong in the numerator or denominator when this metric is selected.

Metric Numerator Denominator

M1 Field_A Field_B

M2 Field_A Field_C

M3 Field_C Field_D

What I would like is for the user to select a metric from the list and then have the charts use the appropriate fields. So, if a user selected M2, certain charts would be based off of Field_A, other charts would be based off of Field_C and finally some charts would be based off of Field_A and Field_C.

In my example, the metrics have to do with how much storage we have in use and/or we have available in our environment. The data is, of course, extremely made up for this example. I created a series of charts as I would like them with one of the numerator / denominator combinations but it doesn't currently change when a selection is made.

In another example, I used a bunch of if/then/else branching to accomplish this goal but I want the number of metrics to be dynamic.

Thank you for your help!

Re: Charting / Calculations Based on Fields Specified in Lookup Table

fosuzuki — Tue, 04 Sep 2012 22:01:58 GMT

Your formula could be something like this:

SUM ($(=only(METRIC_NUMERATOR)))

SUM ($(=only(METRIC_DENOMINATOR)))

The dollar sign expansion will be replaced with the text in the respective field.

Hope this helps

Fernando

Re: Charting / Calculations Based on Fields Specified in Lookup Table

Thu, 06 Sep 2012 13:39:06 GMT

Thank you!

I feel like I have a new super-power. This is exactly what I needed. I updated my demo file so that anyone looking to do something similar would have it to start with ....

Thanks

PeggySue

topic Charting / Calculations Based on Fields Specified in Lookup Table in QlikView

Charting / Calculations Based on Fields Specified in Lookup Table

Re: Charting / Calculations Based on Fields Specified in Lookup Table

Re: Charting / Calculations Based on Fields Specified in Lookup Table