Relative in Bar chart

nvijay5757 — Mon, 29 Aug 2022 14:59:39 GMT

Hi,

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).

please help me thanks.

topic Relative in Bar chart in App Development

Relative in Bar chart