Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

including another expression in a combo chart

Hello experts,

I am currently trying to add to a combo chart a certain expression to display but I dont think I am going at it the correct way.

Attached below are pictures to visualize what I want to achieve and the current qlikview doc I have.

I am trying to get the revenue growth % for the selected dates to display on the analysis chart above every fiscal year.

The formula for the expression is already stated in the text box in qlikview, under (revenue growth % for the selected dates).


Kind regards,

Royce Tang

5 Replies
vinieme12
Champion III
Champion III

haven't checked the app but if you want the placement of those values to be on top , then create a dual expression

example;


=Dual(Num(YourActualExpression,'##.0%') , 0.95%)


Now the values will plot in a straight line of 95%

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.
adamdavi3s
Master
Master

This is possible but might need some fiddling.

Create a new expression with your formula in, and set it to values on data points only, then I believe you can pad it out with carriage returns to try and align it to the top of the chart.

I'll do some digging as I am sure I saw a thread on this somewhere

Capture.PNG

Not applicable
Author

Cheers for that ! may I please ask what carriage returns are btw? I also find that my expression may be wrong as I am required to select 2 dates for it. is it possible to get the dates showing with only 1 or totally no dates being selected ?

adamdavi3s
Master
Master

I might be wrong about this, sorry I thought this would work but it doesn't look like it does (works for the pop up text though)

Just trying some other ideas for you

carriage returns are just a character to add in a new row chr(13)

adamdavi3s
Master
Master

I can't come up with a way of doing this I am afraid