Customize alert message and alert conditions (how to?)
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)
I want to know if the sum(consumption_in_kWh) exceeds 3 over a period of 4 days.
I want to know if there is consumption in (Consumption_in_m3) but not in (consumption_in_kHw) over a period of 3 days.
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.