Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
Userkemiko
Contributor
Contributor

Calculate Measue By Selected Value in Filter Pane

is it Possible to set Measure Column By value from selected value in Filter Pane?

For Example, I have Customer Table with the columns are: Customer Name, Expense, & Income. Also I have Finance Table which has columns Expense and Income. So when I choose Expense in Filter Pane Finance Table, my Line chart will calculate Sum(Expense) of the customers. If I choose Income, it'll be Sum(Income) of the customers.

Thanks before for your help. I'm still newbie in QlikSense

 

1 Reply
gkhetan
Contributor II
Contributor II

Could you confirm, if I have correct understanding of problem statement 

Depending on selection made for dimension field (used in filter pane), measure value in line chart should be adjusted. Possible values of dimension field are as following

a. Expense

b. Income

If yes, please try using below expression

PICK(MATCH(GetFieldSelections(Dimension_Field_Name),'Expense','Income'),SUM(Expense),SUM(Income))

If not, please share more detail.

Thanks,

GKhetan