If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.
I have 4 different rates that I want to multiply against depending on a location. Here is my example
column 2 cost
column 3 rate
So atlanta needs to be cost * 4
chicago needs to be cost * 5
If its in a same script table, then may be like this -
cost*4, cost*5, cost*2,cost*6) as value;
Thanks it’s just a table chart right now.
Not sure but if all the fields are in the same table or properly associated, this should work I think in table chart as well..
Load * Inline [
location, cost, rate
pick(match(location,'atlanta','chicago','cleveland','Miami'),cost*4,cost*5,cost*2,cost*6) as locationcost,
if(location='atlanta',4,(if(location='chicago', 5,if(location='cleveland',2,if(location='Miami',6))))) as rate
Thanks-- didnt work though.
Pl share your table chart, expected output etc Its difficult to identify problem without knowing what and where you are trying the shared expression
@jham55 please find from the attached qvf.