Qlik Community

Ask a Question

New to Qlik Sense

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

Announcements
Our May 2021 end-to-end product release from Data Integration to Data Analytics is out! READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
jwininger
Contributor
Contributor

Conditional Target KPI

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?

4 Replies
skamath1
Creator III
Creator III

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

 

 

 

jwininger
Contributor
Contributor
Author

Where does that code go?

skamath1
Creator III
Creator III

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

jwininger
Contributor
Contributor
Author

Perfect.  That got me what I needed.  Thanks