Skip to main content

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
NEW webinar Dec. 7th: 2023 Outlook, A Pivotal Year for Data Integration SIGN ME UP!
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