in Qlikview they written like: in bar chart -> Relative
=only(if ((Min_cvdcqa_trip_end_air_amb_temp_r_3)<=50 and (Min_cvdcqa_trip_end_air_amb_temp_r_3)>=40, 50, if ((Min_cvdcqa_trip_end_air_amb_temp_r_3)<=-20 and (Min_cvdcqa_trip_end_air_amb_temp_r_3)>=-30, 50,0) ))
the same i have written in Qliksense:
=IF(GetFieldSelections(PARTS)='Body Mount', only(if ((Min_cvdcqa_trip_end_air_amb_temp_r_3)<=50 and (Min_cvdcqa_trip_end_air_amb_temp_r_3)>=40, 0.5, if ((Min_cvdcqa_trip_end_air_amb_temp_r_3)<=-20 and (Min_cvdcqa_trip_end_air_amb_temp_r_3)>=-30, 0.5,0) )))
when we select Filter 'Body Mount' and Enter bin=10,
then it shows one bar 50 and another bar 50. fine.
if i give Enter bin=20, then it showing the bar 50 only. actually it will show 100. in qlikview it is working as Relative.
How will give Relative for this expression:
generally Relative as per my knowledge. Sum(sales)/Sum( total sales).
