Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi
Have a look. Detailed explanation on Dynamic chart
https://www.analyticsvidhya.com/blog/2014/01/customize-reporting-qlikview/
Hope it helps!!
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
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))