Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I'm working on Qlik sense.
I have four column
a) created_date
b) param_name
c) param_value
d) branch_type
another table
a) branch_type
b) Green
c) Amber
d) branch_type
i want set analysis for below tables like this:
sum(Temperature) for branch_type=DEPOT(not for Humidity & vehicle) / count (created_date) for branch_type=DEPOT in terms of same rows of temperature.
(Same for PT)
from this
Step 1--> i got the Avg Temperature
Step 2--> To this Avg temperature. i decide to it that in which category it belongs ( Green, Amber, Red)
divide it by avg of Green, Amber, Red (Predefined Below) and multiplied by 100 to get '% Temperature Compliance'.
Green--> -25,-26,-27,-28...onward-----------Avg of Green = -25
Amber--> -23,-24-------------------------Avg of Amber = -23.5
Red--> -22,-21,-20...onward--------------------Avg of Red = -22
Suppose i got the Avg Temperature (Step 1) is -23.4.
then Now it belongs in Amber so-----> (-23.4/-23.5)*100= 99.57 %
(Avg Temperature/ Avg of (Green/Amber/Red))*100
i had tried it many way but it won't achievable for me.
please give me solution.
created_date | param_name | param_value | branch_type |
---|---|---|---|
01/02/2015 | Humidity | 20 | DEPOT |
01/03/2015 | Temperature | -24 | DEPOT |
01/04/2015 | Temperature | -21 | DEPOT |
01/05/2015 | Temperature | -22 | PT |
01/06/2015 | Temperature | -23 | DEPOT |
01/07/2015 | Temperature | -20 | DEPOT |
01/08/2015 | vehicle | MH | DEPOT |
01/09/2015 | Temperature | -19 | PT |
01/09/2015 | Temperature | -18 | PT |
01/09/2015 | Temperature | -20 | PT |
branch_type | Green | Amber | Yellow |
---|---|---|---|
DEPOT | -25 and Below | -25 to -22 | -22 and above |
PT | -25 and Below | -25 to -22 | -22 and above |
mtoPhilipHandNew to Qlik Sensejpeanbu1984New to QlikView
Message was edited by: Satish Pawar
Check this app
Thanks for Reply. but actualy its not a Perfect solution.
i want it in table in following way
two column ---> 1) branch_type
2) % Compliance
branch_type---> DEPOT, PT
% Compliance ---> 56, 65 (like This)
Hi Satish, I asked a few colleagues to take a look.
Regards,
Mike
i'm using Qlik sense. i think its not possible to take Lable name as Expressions in Qlik sense.