Display percentage that exceeds 100%

[#1]

I would like to know if its possible to display percentage figures which exceeds 100% as >100% or <-100%. Just like the screenshot below

[jvitantonio]

Can you please attach the screenshot?

[jvitantonio]

Ok, then go to your expression and do:

If([yourExpresion]<=-100, '<-100%', IF([yourExpression] >='100', '>100%', [yourExpression]))

where [yourExpression] is the formula you use to get the percentage.

[#4]

I just tried it but don't seem to show any changes. Below is my expression

if((Sum(If((Year=vYear) and (Quarter=vQtr),SegAmount)) - Sum(If((Year=vYear-1) and (Quarter=vQtr),SegAmount)))

/Sum(If((Year=vYear-1) and (Quarter=vQtr),SegAmount))<=-100,'<-100%',if((Sum(If((Year=vYear) and (Quarter=vQtr),SegAmount)) - Sum(If((Year=vYear-1) and (Quarter=vQtr),SegAmount)))

/Sum(If((Year=vYear-1) and (Quarter=vQtr),SegAmount))>=100,'>100%',Sum(If((Year=vYear) and (Quarter=vQtr),SegAmount)) - Sum(If((Year=vYear-1) and (Quarter=vQtr),SegAmount)))

/Sum(If((Year=vYear-1) and (Quarter=vQtr),SegAmount)))

[jvitantonio]

Ok, first of all, let's try changing your expression to set analysis.

Convert Sum(If((Year=vYear) and (Quarter=vQtr),SegAmount) to sum({<Year={$(=vYear)}, Quarter={$(=vQtr)}>} SegAmount)

Sum(If((Year=vYear-1) and (Quarter=vQtr),SegAmount))) to sum({<Year={$(=vYear)-1}, Quarter={$(=vQtr)}>} SegAmount)

and now try

if((sum({<Year={$(=vYear)}, Quarter={$(=vQtr)}>} SegAmount)- sum({<Year={$(=vYear)-1}, Quarter={$(=vQtr)}>} SegAmount))/ sum({<Year={$(=vYear)-1}, Quarter={$(=vQtr)}>} SegAmount) <=-100, '<-100%, IF((sum({<Year={$(=vYear)}, Quarter={$(=vQtr)}>} SegAmount)- sum({<Year={$(=vYear)-1}, Quarter={$(=vQtr)}>} SegAmount))/ sum({<Year={$(=vYear)-1}, Quarter={$(=vQtr)}>} SegAmount) >=100, '>100%', (sum({<Year={$(=vYear)}, Quarter={$(=vQtr)}>} SegAmount)- sum({<Year={$(=vYear)-1}, Quarter={$(=vQtr)}>} SegAmount))/ sum({<Year={$(=vYear)-1}, Quarter={$(=vQtr)}>} SegAmount))

If this doesn't work, please attach your application. We need to test it step by step.

[#6]

I have changed the expression to use set analysis as given below but no luck in getting any results.

Just added a parenthesis to all the vYear-1 script. sum({<Year={$((=vYear)-1)}

The qlikview file is attached for you to check.

Thank you.