Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
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