Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
sspawar88
Creator II
Creator II

Set analysis

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_dateparam_nameparam_valuebranch_type
01/02/2015Humidity20DEPOT
01/03/2015Temperature-24DEPOT
01/04/2015Temperature-21DEPOT
01/05/2015Temperature-22PT
01/06/2015Temperature-23DEPOT
01/07/2015Temperature-20DEPOT
01/08/2015vehicleMHDEPOT
01/09/2015Temperature-19PT
01/09/2015Temperature-18PT
01/09/2015Temperature-20PT
branch_typeGreenAmberYellow
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

4 Replies
anbu1984
Master III
Master III

Check this app

sspawar88
Creator II
Creator II
Author

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
Employee
Employee

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

Regards,

Mike

Regards,
Mike Tarallo
Qlik
sspawar88
Creator II
Creator II
Author

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