Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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