Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I am new to Qlik Sense but I have program experience. I am have a set of sales data by department. I am need to set sales goal for each department. The issue is the percent of change will vary by department. How do I go about apply the variable to each department previous year sales numbers?
You can load the sale data from the dataset.
Example
Sales:
Load Department, Sales from <your filename> ;
Goals:
LOAD * inline [
Department|Goal
Dept1|0.5
Dept2|0.4
Dept3|0.24
] (delimiter is '|');
When you load data, Qlik will associate two set of data on same field (Department).
Where does that code go?
May be you need to learn developing app in Qlik Sense. Use the link to get started with free training available.
Perfect. That got me what I needed. Thanks