topic bar chart in QlikView

bar chart

manoj217 — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: bar chart

prma7799 — Wed, 11 Oct 2017 05:52:06 GMT

Please check this

Adhoc reporting in Qlikview

Qlikview adhoc dimension analisys [My own example]

Re: bar chart

Anonymous — Wed, 11 Oct 2017 06:33:58 GMT

Have a look. Detailed explanation on Dynamic chart

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

Hope it helps!!

Re: bar chart

pradosh_thakur — Wed, 11 Oct 2017 06:48:12 GMT

try something like this

1: create an inline table

load * inline[

field_1

profit

sales

quantity

]

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

Re: bar chart

tresB — Wed, 11 Oct 2017 07:12:13 GMT

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))