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
March 11, 2PM EST: Do More with Qlik - Getting Started wtih Qlik Sense SaaS - Redux. REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
NCKuits
Contributor
Contributor

Simple function help

I am very new to Qlik, so sorry for the bombardment of stupid questions. 

I have 2 simple questions. 

First is, I have a kip field that I want to base the value on being [field1] - [field2] I cannot work out how to do this. 


Also the second question is, currently our new set up is run on a backup database, which i will restore daily from our prod database, I presume my published sheets will see the updated data and there is no manual intervention I need to do?

As I said, sorry about the probably stupid questions, I am just starting out on this. 

1 Reply
lanlizgu
Creator III
Creator III

  1. You have two ways of creating the KPI
    1. in the script as a field: field1 - field2 as field3
    2. on the fly in the App in the visualization you want as a measure: sum(field1)-sum(field2)
  2. Once you have the App ready, in order to update the data you just need to reload the App