bar chart

[manoj217]

i have a bar chart but want to multiple selected expressions how to make it.

i need a list box with profit , quantity,sales if i make selection on profit bar graph need to show sum (profit), if i make selection on quantity it need to reflect on sum(quantity)  how to make it

[prma7799]

Please check this

Adhoc reporting in Qlikview

Qlikview adhoc dimension analisys [My own example]

[Anonymous]

Hi

Have a look. Detailed explanation on Dynamic chart

https://www.analyticsvidhya.com/blog/2014/01/customize-reporting-qlikview/

Hope it helps!!

[pradosh_thakur]

try something like this

1: create an inline table

load * inline[

field_1

profit

sales

quantity

]

2:

add a list box for field_1

3:in expression of bar chart

if(getfieldselection(field_1)='profit',sum(profit),if(getfieldselection(field_1)='quantity',sum(quantity),sum(sales)))

please adjust your field names accordingly and properly  or else it will give syntax error or will not work properly.

regards

Pradosh

[tresesco]

1. You could use an input variable, say, Measure that would have the values exatly the same as your measure fields. Then the expression you could use, like = Sum($(Measure))

2. You can use system field $Field as listbox for selection and then use expression like: = Sum($(=$Field))