Conditional Target KPI

[Anonymous]

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?

[skamath1]

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).

[Anonymous]

Where does that code go?

[skamath1]

May be you need to learn developing app in Qlik Sense.  Use the link to get started with free training available.

https://www.qlik.com/en-US-sense-gettingstarted

[Anonymous]

Perfect.  That got me what I needed.  Thanks