Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hope someone in here can help me understand how to approach this task I have set my self.
I need someone to really explain how to do this in a simple way, and not like showing a caveman a spaceship and telling him "now u build one" (See you in a couple of thousand years then) 🙂
I am using Qlikview personal edition to see if I can generate an app that makes it possible via conditional text objects and alert via pop-up box and email, to find heat meters that have too high consumption over a period of time.
Okay, here we go.
First of all, I need to make (maybe a variable) that is a threshold. (Data I use is below in my example)
Second.
If one of these (alarms=thresholds) are met, then I need to return the Customer,Property_adress,Meter_location,period_of_time(the 3 days)
Customer | Property_adress | Meter_location | Meter_no | Created | kWH | Consump_in_kwh | m3 | consumption_ _in_m3 |
NASA | Nasa street 1 | Rocket fuel heater | 68727665 | 01-03-2019 | 33554 | 1,00 | 3500 | 0 |
NASA | Nasa street 1 | Rocket fuel heater | 68727665 | 02-03-2019 | 33555 | 1,00 | 3501 | 1 |
NASA | Nasa street 1 | Rocket fuel heater | 68727665 | 03-03-2019 | 33556 | 1,00 | 3502 | 1 |
NASA | Nasa street 1 | Rocket fuel heater | 68727665 | 04-03-2019 | 33557 | 4,00 | 3503 | 1 |
NASA | Nasa street 1 | Rocket fuel heater | 68727665 | 05-03-2019 | 33558 | ,00 | 3505 | 2 |
NASA | Nasa street 1 | Rocket fuel heater | 68727665 | 06-03-2019 | 33559 | ,00 | 3506 | 1 |
NASA | Nasa street 1 | Rocket fuel heater | 68727665 | 07-03-2019 | 33559 | ,00 | 3507 | 1 |
So I could get a text object or an alert to activate on RELOAD, where the message would be something like
//
Hi 'NASA'
It seems that your 'Rocket fuel heater ' located on 'Nasa street 1' has exceeded 'sum(consumption_in_kWh)' over a period of 'min(created)' to 'max(created)' This is WAY more than the government granted you in funding.
//
the min 'min(created)' and 'max(created)' are of course the start of the 3 day period and the end where the consumption was too high
When I have this I would like to use in it in an Alert.
Also, I need to use it for a text object was it is shown if NASA is selected.
Quite a mouthful I know.... But if you can help me step by step figure this out.. I will literally build you a freaking spaceship - Star Treck worthy.