Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All
mY cHART 1 now is correct , but i am not able to make the bar all same height.
Hope some one can advise me.
Paul
Hi Paul,
Do you wanna this?
Regards
Hi Manuel
Many thank for your help , it work fine now. After i check your profile , you are high post in QV , no wonder your expression is so powerful , that i am still unable to figure out how you make it work.
Paul
Hi Paul,
I'm dividing x versus z, and the other expression rest 1 the result of this division. If you put the same name you've given the above expression, on the same chart, collect the result of that expression for each dimension value.
Regards!
Hi Manuel
Now i understand how it work now . I also spot some issue , i manage to change the following :-
1) Convert the eXP and rEVENUE to YTD amount instead of now is sum amount, So that i manage to make it able to compare the ratio by company.
2) I also remove the IF , by change the eXP*1 to eXP *1
Many Thank and i can apply the same approach for other ratio. So all chart will look perfect.
Paul
One more point is , i am able to make it work in QS.
You can do it in QlikSense with this:
Expr1: IF(Sum({<eXP={"eXP"}>}Amount*-1)/Sum({<rEVENUE={"rEVENUE"}>}Amount*1)>1,1,Sum({<eXP={"eXP"}>}Amount*-1)/Sum({<rEVENUE={"rEVENUE"}>}Amount*1))
Expr2: 1 - IF(Sum({<eXP={"eXP"}>}Amount*-1)/Sum({<rEVENUE={"rEVENUE"}>}Amount*1)>1,1,Sum({<eXP={"eXP"}>}Amount*-1)/Sum({<rEVENUE={"rEVENUE"}>}Amount*1))
Change name of first expression on second expression by expression 1 content.
If you want to do it YTD, make it on Set Analysis: QlikView App: Simple Year To Date Example (Set Analysis)
Regards!
Hi Manuel
Thank you for your reply again.
I already manage to create the chart using QS with SET expression and it work fine now.
By the way may i know why you need to make use of IF ?
See my expression with out using the IF , i just change the eXP*1 to eXP*-1 in order to remove the negative sign.
Paul
I use IF because if A/B is greather than 1, I will get 1, else I will get the result of A/B.
With that check I discard that have negative values
Regards
Hi Manuel
Good idea . This way I can plot those ratio with + and - %
Paul
Sent from my iPhone