topic Re: how to show the chart expression dynamically? in QlikView

how to show the chart expression dynamically?

Anonymous — Mon, 09 Nov 2015 05:43:23 GMT

Hi,

I have 5 metrics(example(GWP,GEP,GEC,CO,GCD),I need to create list drop down for those.

I need to create a chart based on metrics.

whenever user selects one metrics from list box then related metrics should populate in expression.

How can i make list box and based on that how can i show chart?

Thanks,

Raj

Re: how to show the chart expression dynamically?

Anonymous — Mon, 09 Nov 2015 05:52:33 GMT

Create a Inline at backend/script like:

Test:

Load * inline

[MetricsName, MetricNo

GWP, 1

GEP, 2

GEC,3

CO, 4

GCD,5

];

Now take, MetricsNAme in Listbox, prepare a chart write down their relevant expression,

Now say , you have created expression in Chart Object properties under Expression tab:

Then make it Conditional Enable and write down one condition like:

=MetricNo=1 for GWP //Similarly for Others, Use metric no for others as well..

Hope this will help!!!

Re: how to show the chart expression dynamically?

Anonymous — Mon, 09 Nov 2015 06:00:15 GMT

Hope it will help you!!

PFA..

Re: how to show the chart expression dynamically?

sasikanth — Mon, 09 Nov 2015 06:05:27 GMT

HI ,

Try some thing like,

Load * inline

[

Metric

GWP

GEP

GEC

GCD

];

Create a variable and assign Metric Field to the variable and then use the variable in the expression like,

In variable Overview add a variable vMetric

vMetric=Metric

=sum({<Metric={'(=$(vMetric))'}>}sales)

Re: how to show the chart expression dynamically?

avinashelite — Mon, 09 Nov 2015 06:27:48 GMT

create an inline table for all your metric and then in the expression you have the option of conditional enable for the expression . Based in the user selection i.e. metric you can enable the related metric in the expression .