Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2022, LIVE in Denver CO., May 16-19, 2022. REGISTER NOW TO RECEIVE EARLY BIRD PRICING
cancel
Showing results for 
Search instead for 
Did you mean: 
manoj217
Creator III
Creator III

bar chart

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

4 Replies
prma7799
Master III
Master III

qlikviewnovice
Specialist II
Specialist II

Hi

Have a look. Detailed explanation on Dynamic chart

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

Hope it helps!!

pradosh_thakur
Master II
Master II

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

Learning never stops.
tresesco
MVP
MVP

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

Capture.JPG