topic Re: display arrows with conditions in Management & Governance

display arrows with conditions

zied_ahmed1 — Tue, 30 Oct 2018 09:59:02 GMT

Hello,

I have Two Fields Status and Trend ,

I do this in a script

//---Stable

if("Trend"='Stable' and "Status"='On Track',1,0) as Stable_OnTrack,

if("Trend"='Stable' and "Status"='Minor Variance',1,0) as Stable_Minor,

if("Trend"='Stable' and "Status"='Significant Variance',1,0) as Stable_Significant,

//---Improving

if("Trend"='Improving' and "Status"='On Track',1,0) as Improving_OnTrack,

if("Trend"='Improving' and "Status"='Minor Variance',1,0) as Improving_Minor,

if("Trend"='Improving' and "Status"='Significant Variance',1,0) as Improving_Significant,

//degrading

if("Trend"='Degrading' and "Status"='On Track',1,0) as Degrading_OnTrack,

if("Trend"='Degrading' and "Status"='Minor Variance',1,0) as Degrading_Minor,

if("Trend"='Degrading' and "Status"='Significant Variance',1,0) as Degrading_Significant,

The objectif is is to display an arrow with every condition like this :

Thanks for help

wade12 — Tue, 30 Oct 2018 10:09:16 GMT

qlikview or qlik sense?

zied_ahmed1 — Tue, 30 Oct 2018 10:10:21 GMT

Qlik Sense

wade12 — Tue, 30 Oct 2018 10:46:50 GMT

in qlik sense you can display coloured arrows in a kpi chart using the built-in colour and symbol options like this:

zied_ahmed1 — Tue, 30 Oct 2018 11:02:11 GMT

Thank you but there is not a solution I need just an arrow without value

OmarBenSalem — Tue, 30 Oct 2018 11:09:01 GMT

do the same logic of if then, and paste an arrow directly

if(condition, '' )

and color it by expression, with same logic:

if(conditon, 'red')

and u got ur arrows

here's a list of arrows u can copy and paste :

wade12 — Tue, 30 Oct 2018 11:22:13 GMT

use text & image chart and import arrow image.