Set analysis

sspawar88 — Tue, 26 May 2015 16:13:05 GMT

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

Re: Set analysis

anbu1984 — Wed, 27 May 2015 14:16:41 GMT

Check this app

Re: Set analysis

sspawar88 — Wed, 27 May 2015 15:14:18 GMT

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)

Re: Set analysis

Michael_Tarallo — Tue, 02 Jun 2015 13:51:25 GMT

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

Regards,

Mike

Re: Set analysis

sspawar88 — Wed, 03 Jun 2015 15:07:57 GMT

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

topic Re: Set analysis in App Development

Set analysis

Re: Set analysis

Re: Set analysis

Re: Set analysis

Re: Set analysis