Set analysis

[sspawar88]

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

mto‌PhilipHand‌New to Qlik Sense‌jpe‌anbu1984‌New to QlikView‌

Message was edited by: Satish Pawar

[anbu1984]

Check this app

[sspawar88]

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)

[Michael_Tarallo]

Hi Satish, I asked a few colleagues to take a look.

Regards,

Mike

[sspawar88]

i'm using Qlik sense. i think its not possible to take Lable name as Expressions in Qlik sense.