This field is required.
Only these extensions are allowed(.jpg, .JPG, .jpeg, .JPEG, .gif, .GIF, .png, .PNG)
Tags cannot contain the characters ' /, \\, #, ?, or ; >,< '
Only these extensions are allowed(.zip,.ZIP,.pdf,.PDF,.qvf,.QVF,.qvw,.QVW)
Discussion board where members can learn more about Qlik Sense App Development and Usage.
I'm working on Qlik sense.
I have four column
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)
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.
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.
i'm using Qlik sense. i think its not possible to take Lable name as Expressions in Qlik sense.